Re: Need help on getting Operating System User name
From: Craig M. Wall <cwall_at_petersons.com>
Date: 1996/04/11
Message-ID: <4kjoec$rpd_at_news2.noc.netcom.net>#1/1
Date: 1996/04/11
Message-ID: <4kjoec$rpd_at_news2.noc.netcom.net>#1/1
csmanne_at_knuth.mtsu.edu (Mr. Rao Mannepalli) wrote:
>Hi All,
>I am working on Oracle 7.1, SQL*FORMS 3.0 on sco unix. In one of the forms,
>I am trying to get Operating System "logname" (login name). I used "select
>user from dual'. But it gives me the oracle user name. Is there any function
>which gets the logname.
select substr(osuser,1,8)"logname"
from v$session
where type = 'USER';
Received on Thu Apr 11 1996 - 00:00:00 CEST