RE: Auditing Unique Oracle Users

From: FMHabash <fmhabash_at_gmail.com>
Date: Tue, 3 Mar 2009 19:50:03 -0500
Message-ID: <49add038.47c1f10a.54ee.371a_at_mx.google.com>

I have not, unless developers instrument their apps to provide such details e.g. Action, module, or whatever to uniquely id a session.

-----Original Message-----

From: Peter Barnett <regdba_at_yahoo.com> Sent: Tuesday, March 03, 2009 7:38 PM
To: Oracle-l <oracle-l_at_freelists.org> Subject: Auditing Unique Oracle Users

We are using WebSphere for the application server and Hibernate for connection pooling. The applications are written in java.

One of the problems with this configuration is that the users authenticate to the application and are then connected to the database from an application account.  Auditing this database is useless because we really have know idea who is doing what. It is all through the application.

Has anyone had any success auditing unique user IDs when the user actually logs in through an application?

Pete Barnett
Database Technologies Lead
Regence       

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 03 2009 - 18:50:03 CST