/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

2 votes177 views1 answer
Enum in SQL Server
SQL
1 vote165 views2 answers
Sql select only first occurrence
SQL
0 vote209 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
48 votes278 views3 answers
Psql create database
SQL
0 vote167 views1 answer
Update top 100 sql
SQL
1 vote212 views1 answer
Sql sort column by date
SQL
10 votes176 views4 answers
Primary key sql
SQL
2 votes180 views3 answers
How to check current user in mySQL
SQL
1 vote180 views1 answer
How to group by month using sql server
SQL
0 vote225 views1 answer
Set open file limit mac catalina mysql
SQL