CREATE OR REPLACE TRIGGER CONTROL_LOGON
AFTER LOGON
ON DATABASE
DECLARE
UIP VARCHAR2(300);
PRGRM VARCHAR2(60);
CUSER VARCHAR2(60);
MO VARCHAR2(60);
/******************************************************************************
this trigger is to monitor the control of logon
******************************************************************************/
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS'),USERNAME,PROGRAM,MODULE INTO UIP,CUSER,PRGRM,MO FROM V$SESSION WHERE AUDSID=USERENV('sessionid') and rownum=1;
IF CUSER='SFISM4' AND INSTR(UPPER(PRGRM),'TOAD')>0 AND UIP IN('10.194.128.133','10.194.147.151','10.194.147.188','10.194.147.153') THEN
NULL;
ELSIF CUSER IN ('SFISM4') AND INSTR(UPPER(PRGRM),'TOAD')>0 THEN
INSERT INTO SFIS1.C_LOGIN_LOG_T(SELECT USERNAME,COMMAND,SCHEMANAME,PROGRAM,TERMINAL,SYS_CONTEXT('USERENV','IP_ADDRESS') IP,SYSDATE FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'));
COMMIT;
RAISE_APPLICATION_ERROR(-20001,'該帳號已經被管控');
END IF;
END ;
AFTER LOGON
ON DATABASE
DECLARE
UIP VARCHAR2(300);
PRGRM VARCHAR2(60);
CUSER VARCHAR2(60);
MO VARCHAR2(60);
/******************************************************************************
this trigger is to monitor the control of logon
******************************************************************************/
BEGIN
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS'),USERNAME,PROGRAM,MODULE INTO UIP,CUSER,PRGRM,MO FROM V$SESSION WHERE AUDSID=USERENV('sessionid') and rownum=1;
IF CUSER='SFISM4' AND INSTR(UPPER(PRGRM),'TOAD')>0 AND UIP IN('10.194.128.133','10.194.147.151','10.194.147.188','10.194.147.153') THEN
NULL;
ELSIF CUSER IN ('SFISM4') AND INSTR(UPPER(PRGRM),'TOAD')>0 THEN
INSERT INTO SFIS1.C_LOGIN_LOG_T(SELECT USERNAME,COMMAND,SCHEMANAME,PROGRAM,TERMINAL,SYS_CONTEXT('USERENV','IP_ADDRESS') IP,SYSDATE FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'));
COMMIT;
RAISE_APPLICATION_ERROR(-20001,'該帳號已經被管控');
END IF;
END ;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25850100/viewspace-703943/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
FLASHBACK
下一篇：
RAC DATABASE關機步驟
请登录后发表评论
登录
全部评论
