ROLE_ROLE_PRIVS describes the roles granted to other roles. Information is provided only about roles to which the user has access.
| Column | Datatype | NULL | Description |
|
|
|
| Name of the role |
|
|
|
| Role that was granted |
|
|
| | Signifies that the role was granted with |
Note:
1. Roles granted to DBA
select *
from ROLE_ROLE_PRIVS
where role = 'DBA'
ORDER BY GRANTED_ROLE;
| ROLE | GRANTED_ROLE | ADMIN_OPTION |
| DBA | DELETE_CATALOG_ROLE | YES |
| DBA | EXECUTE_CATALOG_ROLE | YES |
| DBA | EXP_FULL_DATABASE | NO |
| DBA | GATHER_SYSTEM_STATISTICS | NO |
| DBA | IMP_FULL_DATABASE | NO |
| DBA | JAVA_ADMIN | NO |
| DBA | JAVA_DEPLOY | NO |
| DBA | PLUSTRACE | YES |
| DBA | SCHEDULER_ADMIN | YES |
| DBA | SELECT_CATALOG_ROLE | YES |
| DBA | WM_ADMIN_ROLE | NO |
| DBA | XDBADMIN | NO |
2. See also Viewing Privilege and Role Information
Oracle data dictionary views
Oracle dynamic performance views
No comments:
Post a Comment