skip to main content
SQL statements : DCL statements : DROP ROLE
 

DROP ROLE

This statement removes a role from the database. When you drop a role, it is revoked from all users and roles to whom it has been granted and removed from the database.
To support DROP ROLE processing, the IP GETSUPPORT operation must return TRUE for IP_SUPPORT_DROP_ROLE.

Syntax 

DROP ROLE role

Examples

DROP ROLE teller;