Re: who am I - need OSUSER from PL/SQL

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 2 Dec 1999 17:43:46 +0100
Message-ID: <8267h5$977p$1@oceanite.cybercable.fr>

select osuser from v$session where audsid=userenv('SESSIONID');

--
Have a nice day
Michel

<ccyr6798_at_my-deja.com> a écrit dans le message : 8263st$d38$1_at_nnrp1.deja.com...
> I need to get the OSUSer name from a non-priv'd oracle user running a
> stored procedure or kicking a trigger.
>
> I have no problem granting select/creating public synonyms on
> v$session/v$process but still can't figure out which user in the list I
> am. I don't want to turn on auditing just to populate the user_audit
> tables, which also contain the osuser name.
>
> any thoughts?
>
> thanks,
> Cary
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 02 1999 - 10:43:46 CST