Oracle DBA Scripts
Oracle Production support DBA Tips
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
‹
›
Home
View web version
No comments:
Post a Comment