Auditing

[JGolightly]

I would like to be able to identify which tables have been altered during the previous day (inserts, deletes, updates and structural changes).

I presume that auditing would provide the information I need, but I have no idea how to go about it.

I'm running 8i standard edition on NT

Can anyone help ?

[Halo]

audit all on schema_name.table_name;
The audit entries will be inserted in the sys.aud$ table. Keep an eye on the growth of this table.

[pando]

set audit_trail=db in initSID.ora

[JGolightly]

Halo

Do I need to do this for every table ?

Or is there something I can set by say, user ?

[raghucharan]

As he mentioned set this value in your initSID.ora file not for every table

[Halo]

I believe you would have to do that for every table.

[raghucharan]

Hi
You have to set initilization parameter file nothing but init.ora file not for every table and u cant set this for every table.U can set this to DB or OS or NONE

[JGolightly]

If I want to turn off audting for a table, what do I do ?

[raghucharan]

Once u set the parameter.You have to issue an audit command on the objects what u want to audit.At the same time u have noaudit command for the object which you dont want to audit.