Thank you for visiting Spatial DBA - Oracle and ArcSDE.
I have stopped updating the blog.
Please visit Oracle DBA Tips (http://www.oracledbatips.com) for more Oracle DBA Tips.
===============================================================
Oracle 11gR1
DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.
USER_ROLE_PRIVS describes the roles granted to the current user.Column | Datatype | NULL | Description |
GRANTEE | VARCHAR2(30) | Name of the user or role receiving the grant | |
GRANTED_ROLE | VARCHAR2(30) | NOT NULL | Granted role name |
ADMIN_OPTION | VARCHAR2(3) | Indicates whether the grant was with the ADMIN OPTION (YES) or not (NO) | |
DEFAULT_ROLE | VARCHAR2(3) | Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO) |
Note:
1.
select * from DBA_ROLE_PRIVS where grantee = 'DBA';
GRANTEE | GRANTED_ROLE | ADMIN_OPTION | DEFAULT_ROLE |
DBA | XDBADMIN | NO | YES |
DBA | PLUSTRACE | YES | YES |
DBA | JAVA_ADMIN | NO | YES |
DBA | JAVA_DEPLOY | NO | YES |
DBA | WM_ADMIN_ROLE | NO | YES |
DBA | SCHEDULER_ADMIN | YES | YES |
DBA | EXP_FULL_DATABASE | NO | YES |
DBA | IMP_FULL_DATABASE | NO | YES |
DBA | DELETE_CATALOG_ROLE | YES | YES |
DBA | SELECT_CATALOG_ROLE | YES | YES |
DBA | EXECUTE_CATALOG_ROLE | YES | YES |
DBA | GATHER_SYSTEM_STATISTICS | NO | YES |
No comments:
Post a Comment