prevent objects getting dropped by user by mistake

Create or replace trigger check_beforedrop before drop on database 
declare 
oname char(20); 
begin select objectname into oname from secured_objects where upper(objectname)=ora_dict_obj_name; 
if sql%found then 
RAISE_APPLICATION_ERROR(-20001,'You didnot want this object to be dropped'); 
end if; 
exception 
when no_data_found then 
dbms_output.put_line('This object will be dropped'); 
end;

تم تعديل 15 نوفمبر 200421 سنة بواسطة bedooracle