disabling Auditing
I have followed the following steps to implement auditing in my database
1. Configuring audit trail :
a. Check parameter audit for current values.
b. Alter parameter “audit_trail” to “DB_EXTENDED” and “audit_sys_operations” to “true”.
c. Restart database.
d. Run the script file cataudit.sql
e. Grant audit options.
2. Storing audit information :
a. Create Schema.
b. Create table with same structure as of sys.aud$ table.
c. Create a job to execute once in a day to fetch records from sys.sud$ table to this new table in sys user.
d. Delete the record daily from sys.sud$ table.
3. Protecting Audit Trail:
a. Audit select,delete on sys.sud$ by access;
4. Enabling Audit Trail on users:
a. Audit all by username by access;
b. Audit select table by username by access;
c. Audit update table, delete table, insert table by username by access;
d. Audit execute procedure by username by access;
I have followed the above steps to implement auditng in my database
However , I am facing severe space issues on my server and i want to disable Auditing.
I wanted to know the steps to disable auditingg so that i can drop the audit schema and its tablespaces and datafiles.
my plan is to execute the following 2 steps:
1. SQL> alter system set audit_trail=none scope = spfile;
2. SQL> alter system set audit_sys_operations=false scope=spfile;
and then drop the schema and its tablespaces to clear some space.
Kindly Confirm if these are the steps to be followed and if not,What are the steps to be implemented?