Updated on 2024-07-04 GMT+08:00

Displaying a Role

Function

This statement is used to display all roles or roles bound to the user_name in the current database.

Syntax

1
SHOW [ALL] ROLES [user_name];

Keywords

ALL: Displays all roles.

Precautions

Keywords ALL and user_name cannot coexist.

Example

  • To display all roles bound to the user, run the following statement:
    1
    SHOW ROLES;
    
  • To display all roles in the project, run the following statement:
    1
    SHOW ALL ROLES;
    

    Only the administrator has the permission to run the show all roles statement.

  • To display all roles bound to the user named user_name1, run the following statement:
    1
    SHOW ROLES user_name1;