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.

select osuser from v$session;

(with appropriate authorization, of course).

If you are on unix it might be easier to do a host whoami, depending on what you want to do with the info.

>
>
>TIA,
>
>Cliff
>
>
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.

--
These opinions are my own and not necessarily those of Information Quest

or Pebble In The Sky                     http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry jgarry@nospameiq.com
"See your DBA?"  I AM the @#%*& DBA!     Remove nospam to reply.  Sorry.