You are viewing an old revision of this post, from November 14, 2017 @ 19:43:08. See below for differences between this version and the current revision.

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>


  • November 14, 2017 @ 19:43:08 [Current Revision] by Sharing Solution
  • November 14, 2017 @ 19:43:08 by Sharing Solution

Revision Differences

There are no differences between the November 14, 2017 @ 19:43:08 revision and the current revision. (Maybe only post meta information was changed.)

No comments yet.

Leave a Reply