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.