Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Data Permissions Management/ Displaying the Binding Relationship Between All Roles and Users
Updated on 2024-11-08 GMT+08:00
View PDF
Share

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;

Keywords

None

Precautions

The ROLE variable must exist.

Example

1
 
SHOW PRINCIPALS role1;