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.