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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: xiaoyezi.xyz@xxxxxxx
  • Date: Fri, 7 Apr 2006 11:19:07 -0700

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: