Audit Unique User IDs with Connection Pooling

From: Peter Barnett <regdba_at_yahoo.com>
Date: Wed, 24 May 2006 13:57:49 -0700 (PDT)
Message-ID: <20060524205749.48167.qmail@web31603.mail.mud.yahoo.com>

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 experience using connection pooling and actual Oracle user authentication to the database?

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Wed May 24 2006 - 15:57:49 CDT