ÈçºÎ²ÅÄÜÏÞÖÆÓû§¶Ô×Ô¼º¶ÔÏóµÄDDLȨÏÞ

ʱ¼ä:2008-02-29 05:12:00   À´Ô´:ÈüµÏÍø  ×÷Õß:Õ½¹ú·æ  ±à¼­:chinaitzhe
ÎÊÌ⣺ÈçºÎ²ÅÄÜÏÞÖÆÓû§¶Ô×Ô¼º¶ÔÏóµÄDDLȨÏÞ£¨´¥·¢Æ÷ʵÏÖ£©?

½â¾ö´ËÎÊÌâµÄʾÀý£º

create or replace trigger ddl_refuse_trig
before ddl on schema
declare
v_ipaddress varchar2(20);
begin
select sys_context('userenv','ip_address') 
into v_ipaddress from dual;
if v_ipaddress <> '192.168.1.152' then
raise_application_error(-20099,'Sorry,You 
can not execute the command.Please contact the DBA',false);
end if;
end;
/

¹Ø¼ü×Ö£ºÏÞÖÆ,Óû§,¶ÔÏó,DDL,ȨÏÞ,

ÎÄÕÂÆÀÂÛ

¹²ÓР0 Î»ÍøÓÑ·¢±íÁËÆÀÂÛ ´Ë´¦Ö»ÏÔʾ²¿·ÖÁôÑÔ µã»÷²é¿´ÍêÕûÆÀÂÛÒ³Ãæ