DBA FUS‎ > ‎

SYSDBA Privilege Assignments

posted Sep 13, 2010, 6:13 AM by Sachchida Ojha
SELECT USERNAME FROM V$PWFILE_USERS
WHERE USERNAME NOT IN
        (SELECT GRANTEE FROM DBA_ROLE_PRIVS WHERE GRANTED_ROLE='DBA')
        and USERNAME !='INTERNAL' and sysdba='TRUE';
Comments