創建記錄表
create table LOG_INFO
(
LOGIN_DATE DATE,
USERNAME VARCHAR2(20),
IP VARCHAR2(20),
HOST VARCHAR2(50),
OS_USER VARCHAR2(50)
)
(
LOGIN_DATE DATE,
USERNAME VARCHAR2(20),
IP VARCHAR2(20),
HOST VARCHAR2(50),
OS_USER VARCHAR2(50)
)
創建觸發器，登錄失敗記錄
CREATE OR REPLACE TRIGGER log_errors AFTER SERVERERROR ON DATABASE
BEGIN
IF (IS_SERVERERROR (1017)) THEN
insert into system.log_info values(sysdate,'ORA-1017',
sys_context('userenv', 'ip_address'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'));
END IF;
END;
BEGIN
IF (IS_SERVERERROR (1017)) THEN
insert into system.log_info values(sysdate,'ORA-1017',
sys_context('userenv', 'ip_address'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'));
END IF;
END;
登錄成功時候記錄
CREATE OR REPLACE TRIGGER logon_audit
AFTER LOGON ON DATABASE
BEGIN
if (user not in ('SYSMAN', 'SYS', 'SYSTEM')) then
insert into system.log_info
values
(sysdate,
user,
sys_context('userenv', 'ip_address'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'));
end if;
END;
AFTER LOGON ON DATABASE
BEGIN
if (user not in ('SYSMAN', 'SYS', 'SYSTEM')) then
insert into system.log_info
values
(sysdate,
user,
sys_context('userenv', 'ip_address'),
SYS_CONTEXT('USERENV', 'HOST'),
SYS_CONTEXT('USERENV', 'OS_USER'));
end if;
END;
select * from v$sqlarea t where t.PARSING_SCHEMA_NAME='SYSTEM' and t.LAST_LOAD_TIME like sysdate order by t.LAST_ACTIVE_TIME desc
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/15187685/viewspace-751671/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
