• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. DROP OWNED

DROP OWNED

Function

DROP OWNED deletes the database objects of a database role. The role's permissions on all the database objects in the current database and shared objects (databases and tablespaces) are revoked.

Precautions

None.

Syntax

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

Parameter Description

  • name

    Specifies the role name.

    Valid value:

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes all objects that depend on the objects to be deleted.
    • RESTRICT (default): refuses to delete the object if any objects depend on it.