The system table DOMAIN.ROLEPRIVILEGES describes the privileges and roles that have been granted to roles for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the object that was granted to the role |
OWNER |
CHAR(32) |
Name of the owner of the object that was granted to the role |
TABLENAME |
CHAR(32) |
Name of the table for which privileges were granted to the role |
ROLE |
CHAR(32) |
Name of the granted role |
GRANTEE |
CHAR(32) |
Name of the role to which an assignment was made |
PRIVILEGES |
CHAR(30) |
Granted privileges |
GRANTOR |
CHAR(32) |
Name of the user who granted the privileges or role |
CREATEDATE |
DATE(10) |
Date on which the privilege was granted |
CREATETIME |
TIME(8) |
Time at which the privilege was granted |
Evaluating System Tables, ROLEPRIVILEGES
SQL Reference Manual,, Role Name (role_name), Privileges: Overview