I Enable session auditing by running audit session. All work Ok.
Now I want to disable session auditing just for DBSNMP user.
SQL> noaudit session by DBSNMP;
but it does not work auditing still continues
Any ideas ?!!
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Thanks in advance
06-27-2008, 01:56 AM
i have a doubt, we need to disable the parameter "audit_trail".
what is the value for that parameter ?
06-27-2008, 02:00 AM
But I can't do it. I need auditing for the rest of the system I just want to exclude one I don't want to audit
06-27-2008, 10:11 AM
mmhh, not sure if you have a real grip of how AUDIT/NOAUDIT works... are you aware NOAUDIT only stops auditing operations previously enabled by the AUDIT statement? meaning a NOAUDIT statement will cancel something you set using a matching AUDIT one?