Wednesday, January 13, 2010

SYSDBA Privilege Assignments

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';

No comments:

Post a Comment