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";
