troubleshooting Question

Oracle Auditing - How to audit by user

Avatar of szadba
szadbaFlag for United States of America asked on
Oracle Database
6 Comments1 Solution704 ViewsLast Modified:
Hi:
l've read through information about Oracle auditing and have a question. I would like to audit by user but the issue is that all the users (engineers) log on with the same user name and password. I can see their OS_USERNAME which tells me which engineer is logging in as the schema owner.  We basically need to log any select, insert, update, delete, drop, etc. in a schema and be able to trace it back to a particular person since the application and all the software engineers all have the same USERNAME in the dba_audit_trail table. I have audit_trail = db,extended and we are on Oracle Enterprise 11.2.0.2.    I see that the SQL_TEXT and SQL_BIND aren't populated most of the time either - why is this? The Oracle manual says "The SQL_BIND and SQL_TEXT columns are only populated if the AUDIT_TRAIL initialization parameter is set to db,extended."   so is there something I'm missing?
Thank you for any suggestions.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros