RE: 10.2 - Auditing Q - Exclude a user?
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "cjnewman@xxxxxxxxxxxxx" <cjnewman@xxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Nov 2009 09:49:17 -0700
There isn't any way that I know of to do that however you could just schedule a
script to delete records for that user on a regular basis - hourly, daily, etc.
You can run deletes on sys.aud$ just like any other table (assuming you're
authenticated as a user with the required privs). This won't eliminate the I/O
overhead of all the inserts and now additional deletes, but it will at least
save you on storage space and improve your performance whenever you have to run
a query that does a FTS on the aud$ table.
Regards,
Brandon
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Newman, Christopher
Is it possible to use the built in auditing and exclude a single account
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
Other related posts: