Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Data Permissions Management/ Binding a Role
Updated on 2023-03-06 GMT+08:00
View PDF
Share

Binding a Role

Function

This statement is used to bind a user with a role.

Syntax

1
 
GRANT ([db_name].role_name,...) TO (user_name,...);

Keyword

None

Precautions

The role_name and username must exist. Otherwise, an error will be reported.

Example

1
 
GRANT role1 TO user_name1;