noaudit doesn't work
My database has been running in auditing for awhile; however, when I login as system and tried to set it to no auditing, it doesn't stop the auditing. I tried all these:
noaudit select table;
noaudit delete table;
noauddit insert table;
noaudit all whenever successful;
When select from a table, the count from sys.aud$ increased by 1. I even tried the noaudit with login as internal, still not works. Just nothing will stop the auditing, the count on sys.aud$ still increased by 1 with select querry. Can anyone advice please?
This is from the Admin Guide:
"The NOAUDIT statement only specifies auditing options; it does not disable auditing as a whole. To turn auditing off and stop Oracle from generating audit records, set the initialization parameter AUDIT_TRAIL in the database's initialization parameter file as described in "Enabling and Disabling Auditing".
Click Here to Expand Forum to Full Width