/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

2 votes121 views1 answer
Sql percentage with % rounded down
SQL
0 vote111 views1 answer
Mysql get last 2 month data
SQL
3 votes104 views3 answers
Mysql order by list
SQL
0 vote114 views1 answer
Sqlite3_open_v2
SQL
0 vote262 views1 answer
Current month transactions in mysql
SQL
1 vote122 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote108 views1 answer
How to start my sql server on mac
SQL
6 votes95 views2 answers
How to copy data in sql
SQL
0 vote116 views1 answer
Mysql show create db
SQL
0 vote115 views1 answer
Postgre query date
SQL