创建一个系统触发器 create or replace trigger user_logon after logon on database begin insert into erp.log_table (log_user,host_name,log_time,ip_address) values(sys_context('USERENV','CURRENT_USER',30),sys_context('USERENV','HOST',54),sysdate,sys_context('USERENV','IP_ADDRESS',10)); end;
create or replace trigger user_logon
after logon on database
begin
insert into erp.log_table (log_user,host_name,log_time,ip_address)
values(sys_context('USERENV','CURRENT_USER',30),sys_context('USERENV','HOST',54),sysdate,sys_context('USERENV','IP_ADDRESS',10));
end;
再问一下,如果要取得所用当前用户(包括客户机登陆用户)的登陆软件的信息该怎么写呢