Skip to main content
Skip to main content

SHOW-GRANTS

SHOW-GRANTS

Name

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