Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Getting OS user from within SQL
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
![]() |
![]() |