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>
Showing posts with label Oracle see who has been granted SYSDBA. Show all posts
Showing posts with label Oracle see who has been granted SYSDBA. Show all posts
Tuesday, February 5, 2008
Subscribe to:
Posts (Atom)
