Table of Contents Previous Next


3 The SQL Language : 3.3 SQL Commands : 3.3.40 DROP ROLE

3.3.40 DROP ROLE
DROP ROLE -- remove a database role
DROP ROLE name [ CASCADE ]
DROP ROLE removes the specified role. To drop a superuser role, you must be a superuser yourself; to drop non-superuser roles, you must have CREATEROLE privilege.
It is not necessary to remove role memberships involving the role; DROP ROLE automatically revokes any memberships of the target role in other roles, and of other roles in the target role. The other roles are not dropped nor otherwise affected.
Alternatively, if the only objects owned by the role belong within a schema that is owned by the role and has the same name as the role, the CASCADE option can be specified. In this case the issuer of the DROP ROLE name CASCADE command must be a superuser and the named role, the schema, and all objects within the schema will be deleted.

3 The SQL Language : 3.3 SQL Commands : 3.3.40 DROP ROLE

Table of Contents Previous Next