Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Data Permissions Management/ Displaying a Role
Updated on 2023-03-06 GMT+08:00
View PDF
Share

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];

Keyword

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;