Fine-Grained Auditing (FGA)

Fine-Grained Auditing (FGA). Fine grained auditing extends Oracle standard auditing capabilities by allowing the user to audit actions based on user-defined predicates. It is independant of the AUDIT_TRAILparameter setting and all audit records are stored in the FGA_LOG$ table, rather than the AUD$ table. The following example illustrates how fine… Read More


                                                            AUDITING Auditing is for verification purpose     Types of auditing: Privilege level Statement level Object level To enable the auditing  audit_trail=true or db or os To disable the auditing audit_trail=false or none If the value is true it will enable the auditing and audit files… Read More