Re: How to capture the name of a user that logon on the database as sysdba?
- From: "Terry Sutton" <terrysutton@xxxxxxx>
- To: <xiaoyezi.xyz@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 5 Apr 2006 21:58:42 -0700
Take a look at the files in $ORACLE_HOME/rdbms/audit.
--Terry
In sql*plus, when a user connects to database as sysdba, no matter what his
logon nam is, the value of sys_context(‘userenv’,’session_user’) is always
‘sys’.
Then, how I get the real name of the user who logons on database as sysdba?
That is:
SQL>conn system/manager as sydba;
SQL>create user wxy identified by wxy;
SQL>grant sysdba to wxy;
SQL>conn wxy/wxy as sysdba
How can I capture the name of the user ‘wxy’?
Thanks in advance!
Other related posts:
