Re: what does audit_sys_operations actually audit

From: <Mayen.Shah_at_lazard.com>
Date: Wed, 7 Jan 2009 13:43:31 -0500
Message-ID: <OFDFF5DE62.EC28E522-ON85257537.0066A98C-85257537.0066DC8F_at_lazard.com>

Douglas,

audit_sys_operation will audit all activities by session connect as sysdba. Audit records are save in OS files (typically in OH/rdbms/audit)

HTH
Mayen

"Douglas Cowles" <dcowles_at_us.ibm.com> Sent by: oracle-l-bounce_at_freelists.org Jan 07 2009 01:34 PM
Please respond to
dcowles_at_us.ibm.com

To
oracle-l_at_freelists.org
cc

Subject
what does audit_sys_operations actually audit

I turned on audit_sys_operations in a dev database but nothing seems to be being added to the sys.aud$ table.
SQL> show parameter audit_sys_operations;

NAME                                 TYPE        VALUE 


------------------------------------ ----------- 

------------------------------ 

audit_sys_operations                 boolean     TRUE 

SQL> show user;
USER is "SYS"
SQL>
SQL> select sqltext from sys.aud$ where ntimestamp# between to_date('01-07-09 13:15','MM-DD-RR HH24:MI') and sysdate;

SQLTEXT

---

SQL> select count(1) from sys.aud$ where ntimestamp# between to_date('01-07-09 13:15','MM-DD-RR HH24:MI') and sysdate;

  COUNT(1)

---

         1

SQL> create table test(a number);

Table created.

SQL> insert into test values (1);

1 row created.

SQL> delete from test;

1 row deleted.

SQL> drop table test;

Table dropped.

SQL> select count(1) from sys.aud$ where ntimestamp# between to_date('01-07-09 13:15','MM-DD-RR HH24:MI') and sysdate;

  COUNT(1)

---

         1

No new rows added.. What's the deal?

Dc.

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 07 2009 - 12:43:31 CST