DROP OWNED¶
Function¶
DROP OWNED deletes the database objects of a database role.
Important Notes¶
The role's permissions on all the database objects in the current database and shared objects (databases and tablespaces) are revoked.
Syntax¶
DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ];
Parameter Description¶
name
Name of the role whose objects are to be deleted and whose permissions are to be revoked.
CASCADE | RESTRICT
CASCADE: automatically deletes objects that depend on the affected objects.
RESTRICT (default): refuses to delete the objects if any other database objects depend on one of the affected objects.