No question at this time
DBA Top 10
1 A. Kavsek 10900
2 M. Cadot 6200
3 P. Wisse 5000
4 B. Vroman 4500
5 T. Boles 2200
6 . Lauri 2000
7 J. Schnackenberg 1300
8 J. PĂ©ran 1100
9 R. Pattyn 700
10 T. P 500
10 G. Graham 500
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48425
Total active users1512
Act. users last 24h8
Act. users last hour0
Registered user hits last week172
Registered user hits last month818
Go up

Audit_trail No capturing Select,UPDATE etc...
Next thread: SQL*Developer rerurns a Java error
Prev thread: need to speed up backup of large table by using Datapump

Message Score Author Date
Hi Everyone, I have small doubt regarding audit...... srisethudenesh swaminathan Dec 03, 2018, 06:23
Setting the "audit_trail" parameter is the first...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Michel Cadot Dec 03, 2018, 07:52

Follow up by mail Click here


Subject: Audit_trail No capturing Select,UPDATE etc...
Author: srisethudenesh swaminathan, India
Date: Dec 03, 2018, 06:23, 291 days ago
Os info: Linux
Oracle info: 12.1.0.2.0
Message: Hi Everyone,

I have small doubt regarding auditing.

My DB parameter setting Audit_trail=DB;


By setting this parameter what are the details will be captured by default?

Will it capture SELECT,INSERT,DELETE etc.. ???

Kindly Clarify.

Thanks in Advance.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Audit_trail No capturing Select,UPDATE etc...
Author: Michel Cadot, France
Date: Dec 03, 2018, 07:52, 291 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message:
Setting the "audit_trail" parameter is the first step to enable auditing, the next step is to tell Oracle what to audit, for this you have to use AUDIT statement:
https://docs.oracle.com/database/121/SQLRF/statements_4007.htm#SQLRF01107

Note: we are still waiting for your feedback in your previous thread:
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=82383

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here