-
Noaudit Session By User
Hi
I Enable session auditing by running audit session. All work Ok.
Now I want to disable session auditing just for DBSNMP user.
I enter
SQL> noaudit session by DBSNMP;
Noaudit succeeded.
but it does not work auditing still continues
Orcale 10g
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 ?
-
audit_trail=db.
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|