|Lesson 9||Viewing information about roles|
|Objective||List privileges that have been granted to a role.|
DBA_TAB_PRIVSprovides information about the privileges granted on tables. This view contains the following columns:
|the name of the person receiving the grant|
|the owner of the object the privilege is granted on|
|the object the privilege is granted on|
|the user or role who grants the privilege|
|the privilege granted|
|whether the privilege can be re-granted by the grantee|
DBA_TAB_PRIVSview is located in the
SYSschema, so most users will have to include the qualified table identifier,
SYS.DBA_TAB_PRIVS, to select from the table.
ROLE_ROLE_PRIVSview lists the roles granted to a role, so you can investigate a hierarchy of roles.
DBA_ROLEStable lists whether a password is required for a role
SELECT * FROM SYS.DBA_TAB_PRIVS WHERE GRANTOR = 'BIDDER';
BIDDER, use the following SQL command.