No question at this time
The DBA-Village forum
as RSS feed
Site StatisticsEver registered users | 48572 | Total active users | 1389 | Act. users last 24h | 3 | Act. users last hour | 0 | Registered user hits last week | 108 | Registered user hits last month | 299 |
|
Go up
How to audit Noaudit statements - Traditional Auditng
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...... |
     |
Michel Cadot |
Sep 30, 2020, 07:27 |
Subject: |
How to audit Noaudit statements - Traditional Auditng |
Author: |
S SPB, India |
Date: |
Sep 29, 2020, 09:18, 116 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, 116 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, 115 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, 115 days ago |
Score: |
       |
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
|