-- 登陆触发器 create or replace trigger check_client after logon on database begin for c in (select null from v$session where sid=userenv('sid') and program='plsqldev.exe') loop raise_application_error(-20001,'Deny PLSQL Developer connection.'); end loop; end; /
-- 登陆触发器
create or replace trigger check_client
after logon on database
begin
for c in (select null from v$session where sid=userenv('sid') and program='plsqldev.exe') loop
raise_application_error(-20001,'Deny PLSQL Developer connection.');
end loop;
end;
/
如果是9i,直接编译是通不过了,需要对用户授权
grant select on sys.v_$session to 用户名