Use Log4J to audit the user / sql statements.

[chenson]

We have an enterprise security requirement to audit the users who are logged in when SQL statements get executed against the database.

I would like to accomplish this by simply configuring log4i to print out an audit log.

Is there a way out of the box that I can configure log4j to print both the current contextual user and all sql statements going through a wrapped datasource?

[gvl]

Good question,

if you find a way to do this please post it here for others to know as well!

thanx
--
George