'Disable audit object on oracle 11
How can I disable audit objects on Oracle 11? I have tried
NOAUDIT ALL;
NOAUDIT NETWORK;
NOAUDIT SESSION;
NOAUDIT ALL ON DEFAULT;
NOAUDIT SELECT INSERT UPDATE DELETE EXECUTE PROCEDURE;
NOAUDIT PRIVILEGES;
But audit still generate, grows fast and, of course, my db becomes full.
When I query sys.aud, audit objects like insert, delete, update are being logged to sys.aud.
If someone has solution to this problem, please help me.
Solution 1:[1]
Edit your init.ora file so with the parameter AUDIT_TRAIL=NO.
Solution 2:[2]
NOAUDIT works but for not current sessions. next sessions will not add audit data to sys.aud$
Solution 3:[3]
Use the query below to check the the privileges that are active and the to disable them, if that will help..
select username, owner, action_name, priv_used
from dba_audit_object;
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | mmmmmpie |
| Solution 2 | kashif iftikhar |
| Solution 3 | Markus |
