Privilege | Description | GRANT Syntax | REVOKE Syntax |
---|---|---|---|
MODIFY | Grants the ability to drop the specified role. | GRANT MODIFY ON ROLE <role_name> TO <role>; | REVOKE MODIFY ON ROLE <role_name> FROM <role>; |
Examples of granting role permissions
MODIFY permission
The following code example grants the roledeveloper_role
permission to drop the my_role
role: