Trigger ON DELETE or DROP or TRUNCATE
528084May 20 2007 — edited May 20 2007create trigger DDL_GUARD_cact
before DROP or TRUNCATE or DELETE
on cidcb_cac
begin
raise_application_error( -20001, 'You are not allowed to DROP or TRUNCATE table in this schema. ' );
end;
I am try to build a triger so that no one can delete truncate or delete my table in schema but it is showing me error when i m executing it...
ORA-30506: system triggers cannot be based on tables or views
i think i am wrong in writing this query ...can someone guied me in creating this kind of trigger ...i am a user in oracle not administrator......
so how can show error if someone try to do with my table in my schema like HR
thanks in advance....:)