TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
///开启登录失败审计
- AUDIT SESSION WHENEVER NOT SUCCESSFUL;
复制代码 ///持续一段时间后,查询那些用户登录失败
- set lines 180
- col userhost for a20
- SELECT substr(userid, 1, 20) userid
- ,substr(userhost, 1, 50) USERHOST
- ,substr(spare1, 1, 10) spare1
- ,Failed_login_count
- FROM (
- SELECT userid
- ,userhost
- ,spare1
- ,COUNT(1) Failed_login_count
- FROM sys.aud$
- WHERE (
- returncode = 1017
- OR returncode = 28000
- )
- AND (ntimestamp# > (sysdate - 1))
- GROUP BY userid
- ,userhost
- ,spare1
- );
复制代码
///关闭登录失败审计
- NOAUDIT SESSION WHENEVER NOT SUCCESSFUL;
复制代码
|
|