Auditing System Resources 1. There are two types of Auditing a)users and b)Database Row changes 2. User Auditing is supported by a) Signon: Audit Level Profile and b) Audit Reports c)Monitor users online 3. Auditing Database Row changes is supported by a) Audit Trail active Profile b) Help>about this record - online and c)Audit Forms 4. Sign on Audit level Profile can be set to a)None – No monitoring b) User- when he signed in and terminal info c) Responsibility- additional info on time spent on responsibilities d)Form- time spent on a form in addition to b) and c) 5. You can only monitor the users who are being audited by sign on audit from the monitor users form. 6. Audit Trail helps you keep a track of when data changed, who changed it and what was changed. 7. Steps to Implement Audit Trail : a) Identify the tables and columns to be audited b)Create Audit Group c) Specify the columns to be audited d)Identify the Oracle ID’s to be audited e)Run the audit trail update tables report and f)Develop reports as required. 8. You can add more columns to be audited but will have to run the audit trail update report tables each time. 9. Maximum columns you can audit for a table is 240. 10. You cannot audit columns of type, long, raw and long raw 11. Audit trail table column names are a) Audit_user_name b)Audit_time_stamp c)Audit_Transaction_type d)Audit_True_nulls (delimited columns with no changes) 12. Two views are created into the shadow audit tables a) _ac – allows reconstruction of the value at a given time b)_av –simple access when a value was changed. 13. There are no pre-defined audit reports. You will need to query and fetch the info you need. 14. Upgrades do not support audit tables. Archive them and perform all reporting required before the upgrade. 15. You can disable Audit trail any time usine a)Disable- Prepare for archive or b)Disable-Interrupt Auditing. 16. Option a) copies all rows in the audited table to a shadow table and disables the triggers for auditing. You should archive before you purge if you need this data when you re-enable auditing.. 17. Option b) Copies one final row for each modified row (multiple changes to the same row are ignored) 18. You should disable and purge the shadow table before reusing.