创建触发器
create trigger on_logon_trigger
after logon on database
begin
dbms_application_info,set_client_info | sys_contxt | ‘userenv’,'ip_address'));
end;
进行查询
select client_info,machine from v$session;
创建触发器
create trigger on_logon_trigger
after logon on database
begin
dbms_application_info,set_client_info | sys_contxt | ‘userenv’,'ip_address'));
end;
进行查询
select client_info,machine from v$session;