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: