OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Removing Auditing (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Removing Auditing [message #533897]

Thu, 01 December 2011 11:03

OracleDBA2010
Messages: 16
Registered: November 2011
Location: Indianapolis

Junior Member

Hello,

Does any one know how to remove auditing. I have enabled an auditing on an user and I would like to remove it now. Just for that user not for others.

audit all by xyz_user by access;

Report message to a moderator

Re: Removing Auditing [message #533898 is a reply to message #533897]

Thu, 01 December 2011 11:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9017.htm

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Removing Auditing [message #533899 is a reply to message #533897]

Thu, 01 December 2011 11:06

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Execute the exact same NOAUDIT statement.

Regards
Michel

Report message to a moderator

Re: Removing Auditing [message #533901 is a reply to message #533898]

Thu, 01 December 2011 11:19

OracleDBA2010
Messages: 16
Registered: November 2011
Location: Indianapolis

Junior Member

Thank you every one. It worked.

noaudit all by xyz_user;

Report message to a moderator

Re: Removing Auditing [message #533902 is a reply to message #533901]

Thu, 01 December 2011 12:04

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-1652 Issue in Temp Tablespace
Next Topic:	how to switch service

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 09 05:36:57 CST 2026