[Last Call] Learn how to a build a cloud-first strategyRegister Now


Implementing Fine Grained Auditing in Oracle 9I

Posted on 2006-04-11
Medium Priority
Last Modified: 2012-06-21

I want to implement fine grained auditing in oracle 9i, what initialization parameters need to be set as prerequisites?
Question by:Keogh_b
  • 2
LVL 29

Expert Comment

ID: 16430869
You need to set AUDIT_SYS_OPERATIONS, AUDIT_TRAIL, and AUDIT_FILE_DEST initialization parameters.

Author Comment

ID: 16431018
Will this not then invoke auditing on all sql?  if not how is auditing invoked for all sql issued against the entire DB
LVL 29

Accepted Solution

MikeOM_DBA earned 2000 total points
ID: 16437400

NO, you then need to issue audit statements on obkects (or other).

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question