Why not capture the OS user which is available via v$session.osuser or sys_context('USERENV','os_user') ? HTH -- Mark D Powell -- ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: Friday, April 07, 2006 2:19 PM To: xiaoyezi.xyz@xxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: How to capture the name of a user that logon on the database as sysdba? Perhaps you should mention what you are really trying to do? On 4/5/06, xiaoyan <xiaoyezi.xyz@xxxxxxx> wrote: 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! -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist