Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Enable Database Auditing for DDL statements?

OraArchiMar 27 2018 — edited Apr 18 2018

Hello all,

I'd like to enable auditing on the Database just for DDL statements. Is there a mechanism just to enable auditing just for specific type of statements, like DML, DDL, DCL, TCL? I believe we can audit on systax level, but being a large database and tons of users, i'd rather prefer to enable audit for specific line of statements, for eg : DDL statements to begin with.

We are planning to enable auditing and dump the audit files in a seperate file system attached to the database server.

We are on Oracle 12c R2 on RHEL 6.5

Thanks in advance.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 16 2018
Added on Mar 27 2018
3 comments
9,284 views