SCHEMAPRIVILEGES
The system table DOMAIN.SCHEMAPRIVILEGES
describes
the privileges that the current user has for schemas.
|
CHAR(32) |
Name of the schema |
|
CHAR(32) |
Name of the user or role to which the privilege was granted |
|
CHAR(32) |
Name of the user who granted the privileges |
|
CHAR(3) |
Privilege of creating objects in this schema (CREATEIN) was granted (YES | NO) |
|
CHAR(3) |
Privilege of deleting objects in this schema (DROPIN) was granted (YES | NO) |
|
CHAR(3) |
Privilege of changing objects in this schema (ALTERIN) was granted (YES | NO) |
|
CHAR(3) |
Privilege of transferring granted privileges to other users or roles (GRANTOPTION) was granted (YES | NO) |
|
DATE |
Date on which the privilege was granted |
|
TIME |
Time at which the privilege was granted |
SQL Reference Manual, Schema Name (schema_name), Privileges: Overview