Su, Xiaomeng 76a5b1ee83 dli_sqlreference_20240227

Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com>
Co-authored-by: Su, Xiaomeng <suxiaomeng1@huawei.com>
Co-committed-by: Su, Xiaomeng <suxiaomeng1@huawei.com>

2024-03-27 22:02:33 +00:00

2.9 KiB

Raw Permalink Blame History

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,...);

Keywords

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;

Parent topic: Data Permissions Management

2.9 KiB Raw Permalink Blame History