Go up

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......		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, 27 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, 27 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, 26 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, 26 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