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

Alan Nolan-Davies (Alan.Nolan-Davies_at_bcs.org.uk) wrote: [...]
>User is a standard function.
>So to find the current time and user for updating last_updated
>and last_updated_by fields
>do a select sysdate, user from dual.

The USER builtin function returns the Oracle userid, which is not necessarily the same as the OS userid. The original poster was on the right track...you get the OS userid from v$session based on (e.g.) the audit session id, which you get via USERENV:

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

Note that "osuser" may not be a reliable field if the client connected via SQL*Net.

/b

--
Bill Manry  -  Mainframe and Integration Technologies  -  Oracle Corporation
Standard disclaimer applies.