User Tools

Site Tools


oracle:audit_mini-howto

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
oracle:audit_mini-howto [2020/03/18 11:52]
dodger [Format]
oracle:audit_mini-howto [2020/03/20 11:14] (current)
dodger [Auditing Objects]
Line 510: Line 510:
  
  
 +===== Auditing ALL USER actions =====
 +
 +''​audit_trail''​ must be st to ''​db,​extended'':​
 +<code sql>
 +alter system set audit_trail=db,​extended scope=spfile;​
 +</​code>​
 +
 +Restart is needed for this change to be applied (oracle rules...).
 +
 +Then:
 +<code sql>
 +AUDIT ALL BY THEUSERNAME BY ACCESS;
 +AUDIT SELECT TABLE, UPDATE TABLE, INSERT TABLE, DELETE TABLE BY THEUSERNAME BY ACCESS;
 +AUDIT EXECUTE PROCEDURE BY THEUSERNAME BY ACCESS;
 +</​code>​
 +
 +Take care, this will insert a huge number of rows in ''​sys.aud$''​
 ====== Disable audit ====== ====== Disable audit ======
 To simply disable AUDITING on statements: To simply disable AUDITING on statements:
oracle/audit_mini-howto.txt · Last modified: 2020/03/20 11:14 by dodger