DROP ROLE statement The DROP ROLE statement removes the specified SQL role. DROP ROLE statement SQL statementsDROP ROLE rolesdropping

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 .

Syntax DROP 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.

Example DROP ROLE reader;