Base on our auditor requirement, They required active the oracle change log. It checked if there are someone change the Oracle table content via SQLPLUS or Oracle console tool. We don't know how to active it. Pls advise. Thanks.
First things first, all auditor would ask you to enable audit log on Database side. But before you enable that you should weigh the Pros and cons for auditing.
Running database with audit log enabled demands resources as it runs expensive sql and write log files whenever a operation takes place which is under audit.
You can enable Audit trai by setting following parameter in init.ora
audit_trail = [os,db,none]
For writing auditing info on OS you would need to set another parameter..AUDIT_FILE_DEST
and then enable audit for specific functions as advised by your auditors like.
audit delete on user.table by access whenever successful;
You can set audit options at three levels statement, priviledge, object.
Would advise you to read oracle documentation before setting this up.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.