Re: Getting OS user from within SQL

On Wed, 20 May 1998 10:28:49 -0400, Clifford Buetikofer <clifford_buetikofer_at_merck.com> wrote:

>I'm trying to get the OS username, not the Oracle account user name,
>from within a SQL*Plus session. I seem to recall a pseudo-column
>called OS_user, but no luck.
>
>
>TIA,
>
>Cliff

Hi Cliff,

if you want to get this for your own session, use:

SELECT osuser
  FROM v$session
 WHERE audsid = userenv('SESSIONID');

HTH,
Peter

--
Peter Schneider
peter.schneider_at_okay.net Received on Wed May 20 1998 - 15:45:22 CDT