Re: Getting OS user from within SQL

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Wed, 20 May 1998 16:52:02 GMT
Message-ID: <356409d8.11963232@newshost.us.oracle.com>

Do a DESCRIBE on V$SESSION, and you'll see the column you're looking for (OSUSER, that is).

---

SQL> select osuser from v$session;

OSUSER

---

oracle
oracle
oracle
oracle
oracle
oracle
oracle
oracle
JKallman

9 rows selected.

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
>
>
>
> 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.

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Wed May 20 1998 - 11:52:02 CDT