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