The system table SCHEMAPRIVILEGES describes the privileges that the current user has for schemas.
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