Mysql – Grant a user permission to only show a view

Here are some SQL queries that you need to execute to grant the permission for existing user to a specific view.

The first command:
GRANT SELECT ON <database_name>.<view_name> TO <user>@<host>

 

The second command:

GRANT SHOW VIEW ON <database_name>.<view_name> TO <user>@<host>

Revisions

No comments yet.

Leave a Reply