Object documentationSCHEMAPRIVILEGES Locate this document in the navigation structure

 

The system table DOMAIN.SCHEMAPRIVILEGES describes the privileges that the current user has for schemas.

Structure

SCHEMAPRIVILEGES

SCHEMANAME

CHAR(32)

Name of the schema

GRANTEE

CHAR(32)

Name of the user or role to which the privilege was granted

GRANTOR

CHAR(32)

Name of the user who granted the privileges

CREATEIN

CHAR(3)

Privilege of creating objects in this schema (CREATEIN) was granted (YES | NO)

DROPIN

CHAR(3)

Privilege of deleting objects in this schema (DROPIN) was granted (YES | NO)

ALTERIN

CHAR(3)

Privilege of changing objects in this schema (ALTERIN) was granted (YES | NO)

GRANTOPTION

CHAR(3)

Privilege of transferring granted privileges to other users or roles (GRANTOPTION) was granted (YES | NO)

GRANTDATE

DATE

Date on which the privilege was granted

GRANTTIME

TIME

Time at which the privilege was granted

More Information

SQL Reference Manual, Schema Name (schema_name), Privileges: Overview