Help Center/ GaussDB(DWS)/ SQL Syntax Reference (8.1.3.x)/ DDL Syntax/ DROP OWNED
Updated on 2024-09-30 GMT+08:00
View PDF

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

1
 
DROP OWNED BY name [, ...] [ CASCADE | RESTRICT ];

Parameters

  • 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.
Parent topic: DDL Syntax