Database auditing, and fine-grained auditing (FGA) View queries

Audit SYSDBA Activities:

Related system parameters: Audit_sys_operations. Set to True, then each statement published by a user who connects to the database as SYSDBA or Sysoper writes to the audit trail of the operating system.

--Query defines how many audits are made:

SELECT * from Dba_audit_policies;

--Database Audit record:

SELECT * from Dba_audit_trail;

Related parameters: Audit_trail

--fine-grained audit records:

Sleect * from Dba_fga_audit_trail;

Reference instance:

Begin
Dbms_fga.add_policy
(
Object_schema=> ' SCOTT ',
Object_name=> ' T_audit_demo ',
Policy_name=> ' Scott_policy ',
Statement_types=> ' INSERT, UPDATE, DELETE, SELECT '
);
End
/

Database auditing, and fine-grained auditing (FGA) View queries