Oracle Experience
Labels
Apex
BI
BI Publisher
DBA
Dev
Discoverer
Glasssfish
Linux
OBIEE
Office
R11i
R12
R12.2
Windows
Tuesday, April 5, 2016
List users with DBA privilege
Which users having dba provilege assigned, query
dba_role_privs in the SYS schema
SQL>
select * from dba_role_privs where granted_role='DBA';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment