Oracle查看那些用户具有DBA权限
Oracle查看哪些用户具有DBA权限col GRANTEE for a20col granted_role for a20select * from sys.dba_role_privs where granted_role='DBA';GRANTEEGRANTED_ROLEADM DEL DEF COM INH-------------------- --------------------
·
Oracle查看哪些用户具有DBA权限
col GRANTEE for a20
col granted_role for a20
select * from sys.dba_role_privs where granted_role='DBA';
GRANTEE GRANTED_ROLE ADM DEL DEF COM INH
-------------------- -------------------- --- --- --- --- ---
AAA_DBA DBA NO NO YES NO NO
SBBB DBA NO NO YES NO NO
CCC DBA NO NO YES NO NO
DD DBA NO NO YES NO NO
DDD DBA YES NO YES NO NO
ADE DBA NO NO YES NO NO
DQERG DBA NO NO YES NO NO
GEA DBA NO NO YES NO NO
DFQET DBA NO NO YES NO NO
AERG DBA NO NO YES NO NO
ERQG DBA NO NO YES NO NO
...
22 rows selected.
更多推荐
已为社区贡献7条内容
所有评论(0)