RE: Auditing original user in an n-tier environment

I have the same problem. My users are using Cognos and SAS. SAS is in = a pilot project and apparently, it can do the pass through you are = describing. Cognos logs user access to a file. Cognos provides a schema = you can build and load the log files to it for better management. Its = kind of clunky and doesn't give you row level auditing. Is the App = something built in house or a COTS product?

Don Freeman
Database Administrator 1
Pennsylvania Dept of Health
Bureau of Information Technology
717-783-8095 Ext 337

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Rusnak, George A. (SEC-Lee) CTR
Sent: Monday, May 09, 2005 1:51 PM
To: oracle-l_at_freelists.org
Subject: Auditing original user in an n-tier environment

GURUS,
Oracle EE: 9.2.0.5
Hardware: HP-UX

3 tier architecture: Presentation, Application and Database. Language: Cold Fusion

Challenge:=20
How do we capture the user logging into the Presentation layer and pass = that original user id through the Application layer to the database = layer and be able to capture that original user id in the audit logs. = The Application layer always connects to the database as the SAME user = NOT as the original user. We need to know what code goes in what tier. I have read and searched but cannot find a doc on how to do this. With = all the multi-tier architectures out there I was hoping to find a ton of = information on this subject.

THANK YOU, Al Rusnak
* 804-734-8210

• george.rusnak_at_deca.mil

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l