No question at this time
DBA Top 10
1 M. Cadot 10800
2 B. Vroman 6500
3 A. Kavsek 5600
4 J. Schnackenberg 2600
5 P. Wisse 2200
5 J. PĂ©ran 2200
7 T. Boles 600
8 D. Dave 400
9 . Lauri 200
9 R. Rao Kulkarni 200
9 H. Bhangu 200
9 V. Gupta 200
9 A. Bourgeois 200
9 M. Jain 200
9 K. Pingeli 200
9 J. Baet 200
9 B. Jacobs 200
9 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48605
Total active users1406
Act. users last 24h5
Act. users last hour0
Registered user hits last week164
Registered user hits last month694
Go up

How to audit Noaudit statements - Traditional Auditng
Next thread: Oracle Fail-safe
Prev thread: sqlplus hangs after entering username/pwd

Message Score Author Date
Hi Team, Would like to know if there is any met...... S SPB Sep 29, 2020, 09:18
All actions by SYS are audited if you set the "a...... Michel Cadot Sep 29, 2020, 10:18
Thanks Michel, I m looking for DB level audit...... S SPB Sep 30, 2020, 07:09
Do not post content of Metalink/MOS note, this m...... Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts Michel Cadot Sep 30, 2020, 07:27

Follow up by mail Click here


Subject: How to audit Noaudit statements - Traditional Auditng
Author: S SPB, India
Date: Sep 29, 2020, 09:18, 224 days ago
Os info: Any
Oracle info: Any
Message: Hi Team,

Would like to know if there is any method to track the NoAudit statements by SYS users as sysdba?

If I issue NOAUDIT on any enabled audit option, how can I track such activity?

Thanks in advance!

Siva
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to audit Noaudit statements - Traditional Auditng
Author: Michel Cadot, France
Date: Sep 29, 2020, 10:18, 224 days ago
Message:
All actions by SYS are audited if you set the "audit_sys_operations" parameter to TRUE.
They can't be audited by the traditional audit system.

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

Subject: Re: How to audit Noaudit statements - Traditional Auditng
Author: S SPB, India
Date: Sep 30, 2020, 07:09, 223 days ago
Message: Thanks Michel,


I m looking for DB level audit records. I found a metalink note: How to audit the audit/noaudit commands? (Doc ID 2082831.1)

But even after I enable, Its not showing any records under dba_audit_statement table.

As per the note:

[Content removed for copyright reasons. Please check Oracle Support Note 2082831.1]
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: How to audit Noaudit statements - Traditional Auditng
Author: Michel Cadot, France
Date: Sep 30, 2020, 07:27, 223 days ago
Score:   Score: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 PtsScore: 400 Pts
Message:
Do not post content of Metalink/MOS note, this material is copyrighted, posting it here is a violation of your contract with Oracle.

As I said, SYS operations are NOT recorded in the traditional audit trail, so this note does NOT apply to SYS.
If you want these operations to be seen in the DB you have to use the unified auditing, if your version knows it (solutions depend on it and this is why you should post it with your questions).

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