ROLEPRIVILEGES
This
system table describes the privileges and roles that were assigned to roles for which the current user has privileges.Structure
ROLEPRIVILEGES
|
OWNER |
CHAR(32) |
Name of the owner of the object that was assigned to the role |
|
TABLENAME |
CHAR(32) |
Name of the table for which privileges were assigned to the role |
|
ROLE |
CHAR(32) |
Name of the assigned role |
|
GRANTEE |
CHAR(32) |
Name of the role to which an assignment was made |
|
PRIVILEGES |
CHAR(30) |
Assigned privileges |
|
GRANTOR |
CHAR(32) |
Name of the user who assigned the privileges or role |
|
CREATEDATE |
DATE |
Date on which the privilege was assigned |
|
CREATETIME |
TIME |
Time at which the privilege was assigned |