0

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.

mmmmmpie
  • 2,908
  • 1
  • 18
  • 26
yayantritaryana
  • 103
  • 1
  • 3
  • 8

3 Answers3

0

Edit your init.ora file so with the parameter AUDIT_TRAIL=NO.

mmmmmpie
  • 2,908
  • 1
  • 18
  • 26
  • That's my problem, I don't want to restart instance. Already read from oracle doc to use noaudit but it seems not working.. – yayantritaryana Feb 05 '15 at 08:43
  • Yes this is production, i can't restart my server, until now sys.aud always full, and i'm getting tired to truncate sys.aud every 6 hour, any idea on this ? – yayantritaryana Feb 05 '15 at 12:59
  • Yes solve your system tablespace/disk size issue. Disabling auditing on a prod DB is a bad idea. – mmmmmpie Feb 05 '15 at 13:00
  • But how to restore default audit ?, before I execute audit all, everything is normal. I can audit user activity without sys.aud being full .. Is it any possible rollback solution ? – yayantritaryana Feb 05 '15 at 13:05
  • You cannot rollback audit settings. You made a change to a production environment without testing it so you made your bed now sleep in it. Above is how you disable all auditing and I recommend you consult someone before you make your next change. – mmmmmpie Feb 05 '15 at 14:02
0

NOAUDIT works but for not current sessions. next sessions will not add audit data to sys.aud$

kashif iftikhar
  • 1
  • 1
-1

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;
Markus
  • 3,225
  • 6
  • 35
  • 47
AFK
  • 1