Help Center/ Data Lake Insight/ SQL Syntax Reference (Paris Region)/ Spark SQL Syntax Reference/ Data Permissions Management/ Displaying the Binding Relationship Between All Roles and Users
Updated on 2022-12-07 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;

Keyword

None

Precautions

The ROLE variable must exist.

Example

1
 
SHOW PRINCIPALS role1;