Updated on 2024-02-07 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;