Oracle detect invalid password

-- 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 vote334 views1 answer
Count the table indatabase
SQL
0 vote378 views1 answer
Left join vs inner join performance
SQL
2 votes385 views2 answers
Spring import sql
SQL
0 vote388 views1 answer
Order child below the parent in mysqli
SQL
0 vote374 views1 answer
Sql make sure every user is unqiuew
SQL
2 votes359 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote344 views1 answer
Inser into example
SQL
0 vote337 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
3 votes357 views1 answer
Oracle list invalid password ORA-01017
SQL
1 vote372 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL