oracle oem_monitor,oracle的oem_monitor 角色默认包含什么权限呢???

满意答案

kkkkk5292

2014.10.28

采纳率：55%    等级：10

已帮助：1522人

查一下系统数据字典ROLE_SYS_PRIVS就清楚了

SQL> select * from ROLE_SYS_PRIVS where role='OEM_MONITOR';

ROLE PRIVILEGE ADM

------------------------------ ---------------------------------------- ---

OEM_MONITOR MANAGE ANY QUEUE NO

OEM_MONITOR CREATE JOB NO

OEM_MONITOR CREATE SESSION NO

OEM_MONITOR ADVISOR NO

OEM_MONITOR SELECT ANY DICTIONARY NO

OEM_MONITOR ANALYZE ANY NO

OEM_MONITOR ANALYZE ANY DICTIONARY NO

7 rows selected.

要是查角色赋予了那些用户 可以用下面的语句来查

SQL> select * from dba_role_privs where granted_role='OEM_MONITOR';

GRANTEE GRANTED_ROLE ADM DEF

------------------------------ ------------------------------ --- ---

DBSNMP OEM_MONITOR NO YES

SYS OEM_MONITOR YES YES

00分享举报