Want to post your scripts here in this blog ? Email it to snojha@gmail.com. You will be rewarded for your scripts if selected by our experts.

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: