This
system table describes the privileges and roles that were assigned to roles for which the current user has privileges.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(10) |
Date on which the privilege was assigned |
|
CREATETIME |
TIME(8) |
Time at which the privilege was assigned |
See also:
Evaluating System Tables: SAP DB 7.4
,
ROLEPRIVILEGES section