Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Data Permissions Management> Displaying the Binding Relationship Between All Roles and Users
View PDF

Displaying the Binding Relationship Between All Roles and Users

Function

This statement is used to display the binding relationship between roles and a user in the current database.

Syntax

1
 
SHOW PRINCIPALS ROLE;

Keyword

None

Precautions

The ROLE variable must exist.

Example

1
 
SHOW PRINCIPALS role1;