RE: How to capture the name of a user that logon on the database as sysdba?
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Apr 2006 14:29:21 -0400
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
Other related posts:
