Dear Readers, How all of you are doing well & safe. Today I was reading some documents referring new DB enhancements in Oracle 18C & found we can do Oracle’s AUDIT table exports using datapump. I remember some of links in Oracle MOS/Docs mentioning, EXPDP… Read More
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 in Oracle. Auditing is used to track the occurrence of SQL statements in subsequent user sessions. In this article will see how can dba track all types of sql operations (select,insert,update,delete drop,create and alter) of particular user. Auditing is a default feature of the… 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
