SCHEMAPRIVILEGES

Definition

The system table 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 was granted (YES | NO)

GRANTDATE

DATE(10)

Date on which the privilege was granted

GRANTTIME

TIME(8)

Time at which the privilege was granted

See also:

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