SQL> select count(*) from dba_roles; COUNT(*)
----------
51
SQL> select count(distinct GRANTED_ROLE) from dba_role_privs;COUNT(DISTINCTGRANTED_ROLE)
---------------------------
50
SQL> select role from dba_roles where role not in (select distinct GRANTED_ROLE from dba_role_privs);ROLE
------------------------------
GLOBAL_AQ_USER_ROLESQL> select count(distinct PRIVILEGE) from dba_sys_privs;COUNT(DISTINCTPRIVILEGE)
------------------------
202SQL> SELECT DISTINCT PRIVILEGE from dba_sys_privs where privilege not in (select distinct privilege from dba_sys_privs where grantee like 'DBA');PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACESQL> select count(PRIVILEGE) from dba_sys_privs where GRANTEE like 'DBA';COUNT(PRIVILEGE)
----------------
201SQL> select count(*) from role_sys_privs where role like 'DBA'; COUNT(*)
----------
201
SQL> SELECT USERNAME FROM DBA_USERS WHERE USERNAME NOT IN (SELECT DISTINCT GRANTEE FROM
2 SELECT DISTINCT ROLE FROM role_sys_privs);USERNAME
------------------------------
MGMT_VIEW
WK_TEST
XS$NULL
FLOWS_FILES
----------
51
SQL> select count(distinct GRANTED_ROLE) from dba_role_privs;COUNT(DISTINCTGRANTED_ROLE)
---------------------------
50
SQL> select role from dba_roles where role not in (select distinct GRANTED_ROLE from dba_role_privs);ROLE
------------------------------
GLOBAL_AQ_USER_ROLESQL> select count(distinct PRIVILEGE) from dba_sys_privs;COUNT(DISTINCTPRIVILEGE)
------------------------
202SQL> SELECT DISTINCT PRIVILEGE from dba_sys_privs where privilege not in (select distinct privilege from dba_sys_privs where grantee like 'DBA');PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACESQL> select count(PRIVILEGE) from dba_sys_privs where GRANTEE like 'DBA';COUNT(PRIVILEGE)
----------------
201SQL> select count(*) from role_sys_privs where role like 'DBA'; COUNT(*)
----------
201
SQL> SELECT USERNAME FROM DBA_USERS WHERE USERNAME NOT IN (SELECT DISTINCT GRANTEE FROM
2 SELECT DISTINCT ROLE FROM role_sys_privs);USERNAME
------------------------------
MGMT_VIEW
WK_TEST
XS$NULL
FLOWS_FILES
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货