Users can modify most of their own account settings without requiring RBAC permissions, except when altering LOGIN configurations or a SERVICE ACCOUNT.
Examples of granting user permissions
MODIFY permission
The following code example grants the roledeveloper_role permission to drop the my_user user: