SHOW-GRANTS

Name

SHOW GRANTS

Description

This statement is used to view user permissions.

grammar:

  1. 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

    1. SHOW ALL GRANTS;

  2. View the permissions of the specified user

    1. SHOW GRANTS FOR jack@'%';

  3. View the permissions of the current user

    1. SHOW GRANTS;

Keywords

  1. SHOW, GRANTS

Best Practice