auditing
This is an old revision of the document!
Table of Contents
Auditing
See the latest activity on the database
0@@
Has your database migrated to Unified Auditing?
1@@
Show the audit trail (12c)
2@@
Disable unified auditing
3@@
4@@
5@@
6@@
12c auditing is protected
The Unified Audit Trail is well protected. Not even SYS can mess with it.
7@@
Manage the audit trail (12c)
The only way to work with the audit trail is with the DBMS_AUDIT_MGMT package.<br /> Before the audit trail can be purged, you must initialise it. This is a one-off execution of the init_cleanup procedure.
8@@
Set auditing properties
9@@
Check whether audit trail cleanup has been initialised
10@@
Check audit settings
11@@
When was audit trail last purged?
12@@
Set a date to purge to
Setup to purge anything older than 90 days before today
13@@
Recheck
14@@
Run the audit cleanup
15@@
or
16@@
Audit Inserts on a particular table
17@@
Which tablespace is the standard auditing table (AUD$) going to?
18@@
or
19@@
Move the standard audit trail (AUD$) to a different tablespace
Can move both the standard and the fine-grained access (fga) audit trail in one go by specifying “audit_trail_db_std” as audit_trail_type.
20@@
Move the unified audit trail to a different tablespace
21@@
AUD$ has not been cleaned up and is now too big to work with
Trim down the audit table the old-fashioned way…
22@@
auditing.1544130326.txt.gz · Last modified: 2018/12/06 21:05 by 91.177.234.129