what does audit_sys_operations actually audit

From: Douglas Cowles <dcowles_at_us.ibm.com>
Date: Wed, 7 Jan 2009 13:34:51 -0500
Message-ID: <OFC5A9021F.388A44A5-ON85257537.006587A2-85257537.00660FD2_at_us.ibm.com>



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:34:51 CST

Original text of this message