/SQL/Oracle list invalid password ORA-01017

Oracle list invalid password ORA-01017

-- 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

0 vote235 views1 answer
Compression of dabatase mysqldumo
SQL
1 vote294 views1 answer
Hangfire clear all jobs
SQL
0 vote232 views1 answer
Sql select all records from all tables where not empty
SQL
5 votes239 views1 answer
Oracle create table comment
SQL
0 vote228 views1 answer
Sql track modification
SQL
3 votes220 views1 answer
Oracle undo tablespace list by user
SQL
4 votes262 views1 answer
Oracle nls_date_format
SQL
1 vote237 views1 answer
Drush sql-dump
SQL
0 vote235 views1 answer
Sql date d'aujourd'hui
SQL
4 votes221 views2 answers
Sql select except null
SQL