Steve Bell wrote:
> Good day all,
>
> I think this question has been asked before, so please accept my apology in
> advance. I've been unsuccessful searching
> for previous posts.
>
> We have an application (Oracle 8.1.7, Forms 9i, OAS9i) where each user will
> have their own login id. This login will be
> validated by the Application Server. When they connect to the database, all
> users will connect under the same Oracle user.
>
> Using update triggers, we populate an audit field called UPDATED_BY when an
> existing record is updated. For development,
> I just used USER to populate the field.
>
> Is their a way that I can get the username that they used originally to log
> into the application? I could then store
> that in a variable in the update triggers so we could record the exact
> application user id that performed the update?
>
> Any thoughts appreciated.
>
> Steve
>
>
Not sure if this works in a 3-tier environmet, but you could
try userenv.
--
Regards, Frank van Bortel
Received on Fri Oct 31 2003 - 02:41:34 CST
