Saturday, September 6, 2008

Alter user trigger

create or replace trigger alter_trigger
before alter
on database
declare
begin
if (ora_dict_obj_type = 'USER') then
raise_application_error(-20010,'you are not allowed to alter users');
end if;
end;
/