Tuesday, February 5, 2008

Oracle see who has been granted SYSDBA

In Oracle to query who has been granted SYSDBA is done by the v$pwfile_users

SQL> select * from v$pwfile_users;
USERNAME SYSDB SYSOP SYSAS
-------- ----- ----- -----
SYS TRUE TRUE FALSE
MRMESSIN TRUE FALSE FALSE
SQL>

No comments: