记录登录数据库的user和IP 的触发器
create table login (ip varchar(30),u_name varchar(30));
create or replace trigger logon_ip_control
after logon on database
declare
ip STRING(30);
user STRING(30);
begin
SELECT SYS_CONTEXT('USERENV','SESSION_USER') into user from dual;
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into ip from dual;
INSERT into login values(ip,user);
commit;
end;
/