Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Data Permissions Management/ Unbinding a Role
Updated on 2023-11-03 GMT+08:00
View PDF

Unbinding a Role

Function

This statement is used to unbind the user with the role.

Syntax

1
 
REVOKE ([db_name].role_name,...) FROM (user_name,...);

Keyword

None

Precautions

role_name and user_name must exist and user_name has been bound to role_name.

Example

To unbind the user_name1 from role1, run the following statement:

1
 
REVOKE role1 FROM user_name1;