ALTER ROLE
Descriptionβ
The ALTER ROLE statement is used to modify a role.
Syntaxβ
ALTER ROLE <role_name> COMMENT <comment>;
Required Parametersβ
1. <role_name>
The name of the role.
Optional Parametersβ
1. <comment>
The comment of the role.
Access Control Requirementsβ
The user executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| ADMIN_PRIV | USER or ROLE | This operation can only be performed by users or roles with ADMIN_PRIV permissions |
Exampleβ
- Modify the role's comment
ALTER ROLE role1 COMMENT "this is my first role";
