Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Data Permissions/ Displaying the Binding Relationship Between All Roles and Users
Updated on 2024-07-04 GMT+08:00

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;