这个出来的是主机名称“henan_db”
不是用户的 IP地址。
我想获得是登录用户的。
谢谢
我顶 使用informix的审计功能区跟踪那个表。
回复 #12 yhl71 的帖子
:mrgreen: :mrgreen:不怕数据库GAME OVER...
回复 #1 xinmencuoxue 的帖子
create table# cat zytrace.sql
{ TABLE "tiptop".zytrace row size = 75 number of columns = 8 index size = 0 }
create table "tiptop".zytrace
(
tabname char(18 ),
acttype char(1 ),
sid integer,
username char(8 ),
pid integer,
hostname char(16 ),
tty char(16 ),
modtime datetime year to second
)lock mode row;
revoke all on "tiptop".zytrace from "public";
grant all on zytrace to public ;
revoke alter on zytrace from public ;
=================================
Create trigger
#--------------------------------------------------------------------------#
create trigger "tiptop".tri_zy_ins insert on "tiptop".zy_file
after
(
insert into db1:"tiptop".zytrace (tabname,acttype,sid,
username,pid,hostname,tty,modtime) select 'zy_file' ,'I' ,x0.sid ,x0.username
,x0.pid ,x0.hostname ,x0.tty ,CURRENT year to fraction(3) from sysmaster:
"informix".syssessions x0 where (x0.sid = DBINFO ('sessionid') ) );
create trigger "tiptop".tri_zy_upd update on "tiptop".zy_file
after
(
insert into db1:"tiptop".zytrace (tabname,acttype,sid,
username,pid,hostname,tty,modtime) select 'zy_file' ,'U' ,x0.sid ,x0.username
,x0.pid ,x0.hostname ,x0.tty ,CURRENT year to fraction(3) from sysmaster:
"informix".syssessions x0 where (x0.sid = DBINFO ('sessionid') ) );
create trigger "tiptop".tri_zy_del delete on "tiptop".zy_file
after
(
insert into db1:"tiptop".zytrace (tabname,acttype,sid,
username,pid,hostname,tty,modtime) select 'zy_file' ,'D' ,x0.sid ,x0.username
,x0.pid ,x0.hostname ,x0.tty ,CURRENT year to fraction(3) from sysmaster:
"informix".syssessions x0 where (x0.sid = DBINFO ('sessionid') ) );
#----------------------------------------------------------------------------#
RUN: N/下頁R/重新執行E/離開
顯示出下一頁的查詢結果.
--------------------- db1 --------------------- 按 CTRL-W 鍵看輔助說明 -------
tabname zy_file
acttype D
sid 319151
usernamekevin
pid 11388
hostnameapserver1
tty /dev/pts/265
modtime 2009-04-08 18:44:06
[ 本帖最后由 p3505 于 2009-11-13 12:06 编辑 ] 用审计功能吧，
比如我这里的业务就是这样分类：
先做好角色分离：
前台连接用户，批作业用户，后台维护人员A，后台维护人员B，后台维护人员C.....
开启审计时，只需要对 后台维护人员A，后台维护人员B，后台维护人员C进行审计就行了，数据库不会OVER。
页:
1
[2]