dba:oracle:howtos:audit_mini-howto
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
oracle:audit_mini-howto [2018/09/04 07:45] – [Query everything BUT LOGIN events] dodger | oracle:audit_mini-howto [2020/04/21 08:59] – [Change tablespace] dodger | ||
---|---|---|---|
Line 63: | Line 63: | ||
END; | END; | ||
/ | / | ||
+ | |||
+ | BEGIN | ||
+ | SYS.DBMS_AUDIT_MGMT.set_audit_trail_location( | ||
+ | audit_trail_type | ||
+ | audit_trail_location_value => ' | ||
+ | END; | ||
+ | / | ||
</ | </ | ||
Line 211: | Line 217: | ||
COLUMN INSTANCE_NUMBER FORMAT 9999 ; | COLUMN INSTANCE_NUMBER FORMAT 9999 ; | ||
COLUMN SCN FORMAT 99999999999 ; | COLUMN SCN FORMAT 99999999999 ; | ||
- | COLUMN SQL_BIND FORMAT | + | COLUMN SQL_BIND FORMAT |
- | COLUMN SQL_TEXT FORMAT | + | COLUMN SQL_TEXT FORMAT |
COLUMN OBJ_EDITION_NAME FORMAT A10 ; | COLUMN OBJ_EDITION_NAME FORMAT A10 ; | ||
</ | </ | ||
Line 510: | Line 516: | ||
+ | ===== Auditing ALL USER actions ===== | ||
+ | |||
+ | '' | ||
+ | <code sql> | ||
+ | alter system set audit_trail=db, | ||
+ | </ | ||
+ | |||
+ | 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; | ||
+ | </ | ||
+ | |||
+ | Take care, this will insert a huge number of rows in '' | ||
====== Disable audit ====== | ====== Disable audit ====== | ||
To simply disable AUDITING on statements: | To simply disable AUDITING on statements: |
dba/oracle/howtos/audit_mini-howto.txt · Last modified: 2023/01/31 08:28 by dodger