【MySQL】How to grant a user permission to only view a mysql view?

Grant a user permission to only view a mysql view

https://stackoverflow.com/questions/3108656/grant-a-user-permission-to-only-view-a-mysql-view

 

GRANT SELECT ON <database_name>.<view_name> TO  <user>@<host> IDENTIFIED BY '<password>';

GRANT SHOW VIEWON <database_name>.<view_name> TO <user>@<host>IDENTIFIED BY '<password>';

 

请注意，执行create view命令的用户（称为视图定义者）也对此有影响，如果使用视图的definer ！= 用户，那么这可能会造成很大的混乱。 

例如，如果定义者仅对基础表具有select权限，而另一个用户对视图具有update权限，则尝试更新视图将导致权限被拒绝错误。

 

 

 

Grant permissions on views, deny select on tables

https://dba.stackexchange.com/questions/86802/grant-permissions-on-views-deny-select-on-tables

 

MySQl SHOW GRANTS Statement

https://dev.mysql.com/doc/refman/8.0/en/show-grants.html

 

How to Use MySQL GRANT Statement To Grant Privileges to a User

http://www.mysqltutorial.org/mysql-grant.aspx