The system table DOMAIN.SCHEMAPRIVILEGES describes the privileges that the current user has for schemas.
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 |
SQL Reference Manual, Schema Name (schema_name), Privileges: Overview