| 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: