create or replace trigger logonallow
after logon on database Begin if ora_client_ip_address<>'10.32.10.239' and ora_login_user='MARS' THEN RAISE_APPLICATION_ERROR(-20001, 'You are not authorized to login into this machine shy'); END IF; end;本文共 283 字，大约阅读时间需要 1 分钟。
create or replace trigger logonallow
after logon on database Begin if ora_client_ip_address<>'10.32.10.239' and ora_login_user='MARS' THEN RAISE_APPLICATION_ERROR(-20001, 'You are not authorized to login into this machine shy'); END IF; end;转载于:https://blog.51cto.com/aixuexi/728874