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
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?
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.