Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Disable database audit
btidba
post Apr 10 2017, 10:28 AM
Post #1


Advanced Member
***

Group: Members
Posts: 170
Joined: 30-September 13
Member No.: 49,003



Hi,

I need to disable the audit definitly in a database :

- How can I do it from sqlplus command line..?
- ..and via Sql Developper?

Many thanks
Go to the top of the page
 
+Quote Post
burleson
post Apr 10 2017, 01:38 PM
Post #2


Advanced Member
***

Group: Members
Posts: 13,476
Joined: 26-January 04
Member No.: 13



Hi,

>> I need to disable the audit definitly in a database :

Please read:

http://dba-oracle.com/t_audit_trail_tips.htm




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
btidba
post Apr 11 2017, 03:59 AM
Post #3


Advanced Member
***

Group: Members
Posts: 170
Joined: 30-September 13
Member No.: 49,003



Hi ,

Thank you!

And if I want to disable the audit for a specific DML action on a specific table , for example I have a specific policies from the table DBA_AUDIT_POLICIES, how to disable the audit policy of TOTO_1_PKV_AUDIT ?

OBJECT_SCHEMA OBJECT_NAME POLICY_OWNER POLICY_NAME POLICY_TEXT POLICY_COLUMN ENABLED SEL INS UPD DEL AUDIT_TRAIL POLICY_COLUMN_OPTIONS
PROD TOTO_1 PROD TOTO_1_PKV_AUDIT PROD.CHD_AUDIT() = 1 ID YES YES NO YES YES DB ANY_COLUMNS
PROD TOTO_2 PROD TOTO_2_PKV_AUDIT PROD.CHD_AUDIT() = 1 ID YES YES NO YES YES DB ANY_COLUMNS
PROD TOTO_3 PROD TOTO_3_PKV_AUDIT PROD.CHD_AUDIT() = 1 ID YES YES NO YES YES DB ANY_COLUMNS
PROD TOTO_4 PROD TOTO_4_PK_AUDIT PROD.CHD_AUDIT() = 1 LABE YES NO NO YES NO DB ANY_COLUMNS

Thanks and Regards
Go to the top of the page
 
+Quote Post
burleson
post Apr 11 2017, 10:25 AM
Post #4


Advanced Member
***

Group: Members
Posts: 13,476
Joined: 26-January 04
Member No.: 13



Hi,

NOAUDIT
SELECT, INSERT, DELETE
ON
scott.emp
WHENEVER SUCCESSFUL;




--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 25th July 2017 - 09:30 PM