SHOW GRANTS

Description

This statement is used to view user permissions.

grammar:

SHOW [ALL] GRANTS [FOR user_identity];

illustrate:

1. SHOW ALL GRANTS can view the permissions of all users.
2. If user_identity is specified, view the permissions of the specified user. And the user_identity must be created by the CREATE USER command.
3. If user_identity is not specified, view the permissions of the current user.

Example

1. View all user permission information

   SHOW ALL GRANTS;

2. View the permissions of the specified user

   SHOW GRANTS FOR jack@'%';

3. View the permissions of the current user

   SHOW GRANTS;

Keywords

SHOW, GRANTS

Best Practice