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 [2019/07/18 07:17] – external edit 127.0.0.1 | oracle:audit_mini-howto [2020/03/20 11:14] – [Auditing Objects] dodger | ||
---|---|---|---|
Line 211: | Line 211: | ||
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 510: | ||
+ | ===== 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