/SQL/Oracle list invalid password logon denied

Oracle list invalid password logon denied

-- Detects invalid password fails (ORA-01017)
SELECT username,
       os_username,
       userhost,
       client_id,
       trunc(timestamp),
       count(*) as failed_logins
FROM dba_audit_trail
WHERE returncode = 1017
  AND --1017 is invalid username/password
    timestamp > sysdate - 30
GROUP BY username, os_username, userhost, client_id, trunc(timestamp);

Similar codes

3 votes122 views1 answer
Start mysql server linux terminal
SQL
0 vote150 views2 answers
Sql query print strings and int
SQL
0 vote131 views1 answer
Sql create table with references not primary key
SQL
0 vote132 views1 answer
Mariadb cast to int
SQL
0 vote118 views1 answer
Prepared statement mysql java delete selected rows
SQL
-1 vote182 views4 answers
Full outer join in sql
SQL
0 vote136 views1 answer
Closure in sql
SQL
2 votes133 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote119 views1 answer
Mysql datetime with timezone offset
SQL
0 vote131 views1 answer
Sql server 2012 create or alter procedure
SQL