Re: Q: Get OS Userid
From: Mark Miller <mem8321_at_u.cc.utah.edu>
Date: 19 Jun 1994 15:51:19 -0600
Message-ID: <2u2ekn$b6u_at_u.cc.utah.edu>
Date: 19 Jun 1994 15:51:19 -0600
Message-ID: <2u2ekn$b6u_at_u.cc.utah.edu>
In article <1994Jun19.162306.24152_at_ericsson.se>,
BO/EBC/KX/RGFC Roger Bjaerevall 08-682 4851 <ebcrbj_at_ebcw150.ericsson.se> wrote:
>Is it possible to get the OS userid of the current user (SUN OS)?
>
>The 'SELECT user FROM dual' call does only return current ORACLE userid.
>I did not find any matching parameter to the USERENV() call either.
>
We had this problem before too. Somehow it seems overkill to create
a separate Oracle account for each user on a 500 user system.
The solution is to write a user exit using Pro*C that uses a local OS function (e.g. logname() ) to get the system userid and return it to SQL*FORMS. Received on Sun Jun 19 1994 - 23:51:19 CEST