DBA_RSRC_MANAGER_SYSTEM_PRIVS displays information about all the users and roles that have been granted the ADMINISTER_RESOURCE_MANAGER system privilege, which is granted using the DBMS_RESOURCE_MANAGER_PRIVS package. This privilege is not granted through the GRANT SQL statement.
USER_RSRC_MANAGER_SYSTEM_PRIVS displays information about the users who are granted system privileges for the DBMS_RESOURCE_MANAGER package. This view does not display the GRANTEE column.
| Column | Datatype | NULL | Description |
|
|
|
| User or role receiving the grant |
|
|
|
| Name of the system privilege |
|
|
| | Indicates whether the grant was with the |
Note:
1.
select * from DBA_RSRC_MANAGER_SYSTEM_PRIVS;
| GRANTEE | PRIVILEGE | ADMIN_OPTION |
| DBA | ADMINISTER RESOURCE MANAGER | YES |
| SYS | ADMINISTER RESOURCE MANAGER | NO |
| MDSYS | ADMINISTER RESOURCE MANAGER | YES |
| WKSYS | ADMINISTER RESOURCE MANAGER | NO |
| EXP_FULL_DATABASE | ADMINISTER RESOURCE MANAGER | NO |
| IMP_FULL_DATABASE | ADMINISTER RESOURCE MANAGER | NO |
Oracle data dictionary views
Oracle dynamic performance views
No comments:
Post a Comment