The system table TABLEPRIVILEGES describes the privileges that the current user has for tables.
TABLEPRIVILEGES
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
GRANTOR |
CHAR(32) |
Name of the user who granted the privileges |
GRANTEE |
CHAR(32) |
Name of the user or role to which an assignment was made |
PRIVILEGES |
CHAR(30) |
Granted privileges |
IS_GRANTABLE |
CHAR(3) |
Privilege to grant the received privilege to another user/role (YES | NO) |
See also:
Evaluating System Tables, TABLEPRIVILEGES
SQL Reference Manual, Privileges: Overview