Noaudit Session By User
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
i have a doubt, we need to disable the parameter "audit_trail".
what is the value for that parameter ?
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
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width