Oracle Sql Statement Audit User

Untuk melakukan audit pada database oracle, kita perlu mengaktifkan audit user. Berikut langkah-langkah mengaktifkan audit user pada database oracle :

Enable Audit user :

CREATE AUDIT POLICY nama_audit_policy
ACTIONS DELETE, INSERT, UPDATE, SELECT
WHEN 'SYS_CONTEXT(''USERENV'', ''SESSION_USER'') = ''USER_DATABASE'''
EVALUATE PER SESSION;

AUDIT POLICY nama_audit_policy;

SELECT object_schema,
object_name,
object_type,
audit_option,
condition_eval_opt,
audit_condition
FROM audit_unified_policies
WHERE policy_name = 'NAMA_AUDIT_POLICY';

SELECT * FROM AUDIT_UNIFIED_ENABLED_POLICIES;

Check Audit trail :

EXEC DBMS_AUDIT_MGMT.flush_unified_audit_trail;

SELECT *
FROM unified_audit_trail
WHERE dbusername = 'USER_DATABASE'
ORDER BY event_timestamp desc;

Remove Audit :

NOAUDIT POLICY nama_audit_policy;

DROP POLICY nama_audit_policy;

Sekian tutorial audit kali ini. Happy Coding 🙂