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;