Background documentationPrivilege Specification for a Schema (schema_priv_spec) Locate this document in the navigation structure

 

A privilege specification for a schema (schema_priv_spec) defines a set of privileges in a schema.

Structure

Syntax Syntax

  1. <schema_priv_spec> ::=
      <schema_privilege> ON <schema_name>,...
    
    <schema_privilege> ::=
      CREATEIN
    | DROPIN
End of the code.
Explanation

The schema name must identify an existing schema but cannot be the same as the name of a database user.

The current database user must be the owner of all schemas identified by the schema name.

CREATEIN

The CREATEIN privilege enables you to create database objects in the specified schema.

DROPIN

The DROPIN privilege enables you to delete database objects from the specified schema. All database users that have been granted this privilege for a schema can delete any objects in the schema, irrespective of whether they created these objects themselves.