SHOW GRANTS

    Grammar: SHOW [ALL] GRANTS [FOR user_identity];

    1. SHOW ALL GRANTS can view the privileges of all users.
    2. If you specify user_identity, view the permissions of the specified user. And the user_identity must be created for the CREATE USER command.
    1. View all user rights information

    SHOW ALL GRANTS;

    1. View the permissions of the specified user

    SHOW GRANTS;