DROP ROLE statementThe DROP ROLE statement removes the specified SQL role.DROP ROLE statementSQL statementsDROP ROLErolesdropping
A role is created by a .
Only the
database owner can drop
a role.
For more information on roles, see "Using SQL roles" in the
.
SyntaxDROP ROLE roleName
Dropping a role has the effect of removing the role from the database
dictionary. This means that no session user can henceforth set that role (see
), and any existing sessions
that have that role as the current role (see
) will now have a NULL
CURRENT_ROLE. Dropping a role also has the effect of revoking that role from any
user and role it has been granted to. See
for information on how
revoking a role may impact any dependent objects.