利用触发器锁住自己的代码防止他人改动
create or replace trigger LockSource
before
create
on SCHEMA
declare
begin
if SYS_CONTEXT('USERENV','OS_USER') = '自己的机器名'
then
return;
end if;
if ora_dict_obj_name in (
'xxxx1_PACKAGE',
'xxxx2_PACKAGE'
)
then
raise_application_error(-20001, 'Stop!!!');
end if;
end LockSource;
/