Re: How to find OS username for a session??

Hi,

Yes, V$SESSION is the right view :

SELECT OSUSER
FROM V$SESSION
WHERE TERMINAL = USERENV('TERMINAL')
AND AUDSID = USERENV('SESSIONID')
/

Govindhan Padmavijayam

enduser_at_enduser.com (EndUser) wrote:
>you want to learn some of the DBA views. check your
>admin, or sql reference in the appendix at the back.
>there are views that list users, you will need to
>pick up the PID from one table, and query another to
>get the name.
>
>--
>
>In article <4a455t$ft3_at_crissy.ge.com>, Donna Kray
><kray.donna_at_mlink.motors.ge.com> wrote:
>
>> What view do I need to use to find the OS username for that paricular
>> session? I am using it in a trigger to update an "updated_by" field and I
>> want username *and* the OS username. Is v$session the correct view? And
>> if so, how do I get the data for only that particular session?
>>
>> SELECT USERNAME, OSUSER
>> FROM ????
>> [WHERE ????];
>>
>> Thanks, DL Kray
>> kray.donna_at_mlink.motors.ge.com
Received on Mon Dec 11 1995 - 00:00:00 CET