Re: How to capture the name of a user that logon on the database as sysdba?

From: Terry Sutton <terrysutton_at_usa.net>
Date: Wed, 5 Apr 2006 21:58:42 -0700
Message-ID: <00b401c65937$101a7300$6400a8c0@TerrySutton>

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!

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 05 2006 - 23:58:42 CDT