Help Center/ Data Warehouse Service / SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP OWNED
Updated on 2025-09-18 GMT+08:00
View PDF

DROP OWNED

Function

DROP OWNED deletes the database objects of a database role.

Precautions

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 ];

Parameter Description

Table 1 DROP OWNED parameters

Parameter

Description

Value Range

name

Name of the role whose objects are to be deleted and whose permissions are to be revoked.

An existing role name.

CASCADE | RESTRICT

Specifies how to process related data in the dependent object when a delete operation is performed.
  • CASCADE: automatically deletes objects that depend on the affected objects.
  • RESTRICT (default): refuses to delete objects with dependent objects.

Example

Remove all database objects owned by role u1.

1
 
DROP OWNED BY u1;
Parent Topic: DDL Syntax