Application user name in Audit triggers

From: Steve Bell <stephenb_at_sympatico.ca>
Date: Fri, 24 Oct 2003 11:23:43 -0400
Message-ID: <Rvbmb.10754$VQ3.531664@news20.bellglobal.com>

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 Received on Fri Oct 24 2003 - 10:23:43 CDT