Wednesday 22 January 2014

Find a list of all users with DBA privilege in Oracle

Problem: Find a list of all users with DBA privilege in Oracle

Solution:

select * from dba_role_privs where granted_role='DBA';

No comments:

Post a Comment