Ask the Expert

Turning on audit trail

How do I turn on audit trail for specific statement insert?

    Requires Free Membership to View

First, you have to set your AUDIT_TRAIL initialization parameter to DB and bounce your database. Then issue a statement similar to the following:

AUDIT INSERT ON schema.table;

The audit records will be placed in SYS.AUD$ and can be viewed through DBA_AUDIT_* views.

This was first published in April 2004

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: