Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Getting OS user from within SQL

Re: Getting OS user from within SQL

From: Lothar Armbrüster <lothar.armbruester_at_rheingau.netsurf.de>
Date: 20 May 98 21:13:10 +0100
Message-ID: <471.444T526T12733201@rheingau.netsurf.de>


On 20-Mai-98 15:28:49 Clifford Buetikofer 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.

Have a look at V$SESSION. There you should find what you are looking for,

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |

Received on Wed May 20 1998 - 15:13:10 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US