Updated on 2023-11-03 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;

Keyword

None

Precautions

The ROLE variable must exist.

Example

1
SHOW PRINCIPALS role1;