Updated on 2024-11-08 GMT+08:00

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

Keywords

None

Precautions

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

Example

1
GRANT role1 TO user_name1;