DROP ROLE
Syntax
Description
Drops a Custom Role within the Organization. Built-in roles cannot be dropped.
A role that is the owner of any objects cannot be dropped. Use GRANT OWNERSHIP to transfer ownership of the object to another role first.
A role cannot be dropped if it is granted any other roles. Use REVOKE ROLE to revoke any granted roles before dropping the role.
Only the owner or a role (or a role with MANAGE_MEMBERS) can drop a role.
Examples
Last updated