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

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