Hi,
I am not able set audit for a particular object in oracle 8i.Please anyone help me to do so.
Following are the steps followed:-
Added in the initialization parameter in init.ora file and restart the database.
AUDIT_TRAIL = DB

wrote the following statement from System user once db is UP.
AUDIT SELECT, INSERT, DELETE ON sysadm.ps_projects BY ACCESS WHENEVER SUCCESSFUL;

Then to monitor what all activities going on this table.

select * from DBA_AUDIT_OBJECT where obj_name='PS_PROJECTS';

but still was able to see the select statements written for this record.

Regards,
Pragyan