SQL> select * from DBA_ROLE_PRIVS where GRANTED_ROLE='RESOURCE';GRANTEE GRANTED_ROLE ADM DEF
------------------------------ ------------------------------ --- ---
AURORA$JIS$UTILITY$ RESOURCE NO YES
CTXSYS RESOURCE NO YES
DBSNMP RESOURCE NO YES
MTSSYS RESOURCE NO YES
ORDPLUGINS RESOURCE NO YES
ORDSYS RESOURCE NO YES
OSE$HTTP$ADMIN RESOURCE NO YES
OUTLN RESOURCE NO YES
PLATE RESOURCE NO YES
SCOTT RESOURCE NO YES
SYS RESOURCE YES YES已选择11行。已用时间: 00: 00: 00.71
SQL>
------------------------------ ------------------------------ --- ---
AURORA$JIS$UTILITY$ RESOURCE NO YES
CTXSYS RESOURCE NO YES
DBSNMP RESOURCE NO YES
MTSSYS RESOURCE NO YES
ORDPLUGINS RESOURCE NO YES
ORDSYS RESOURCE NO YES
OSE$HTTP$ADMIN RESOURCE NO YES
OUTLN RESOURCE NO YES
PLATE RESOURCE NO YES
SCOTT RESOURCE NO YES
SYS RESOURCE YES YES已选择11行。已用时间: 00: 00: 00.71
SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货