Questions on Oracle Database Auditing

I am Oracle version 8.1.6.2 on HP UNIX 11i. I cannot change my version no and answer to my question perhaps will not change if I was on a later version.

I want to audit schema changes:

I can enter:
audit create table;
audit alter table;

but get an error when I enter:
audit drop table;

I get following error:

SQL> audit drop table;
audit drop table
*
ERROR at line 1:
ORA-00956: missing or invalid auditing option

After doing some search on Google, I found that I can enter audit table
(it will automatically audit create table, audit drop table but probably not audit alter table).

Where can I see what is included with:
audit table

Also why Oracle does not like
audit drop table
in the first place.

When I look audit_actions it shows me drop table but not table. What logic Oracle is using behind the scenes.

I have read chapters on Database Auditing several times in Oracle Database Administration Guide but do not find answers there.

Prem Received on Wed Jan 26 2005 - 12:42:34 CST