/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 vote310 views2 answers
Insert into
SQL
1 vote292 views1 answer
Postgresql convert text to float
SQL
0 vote308 views1 answer
Postgresql heritage
SQL
1 vote323 views1 answer
Load mysql dumb
SQL
0 vote298 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote321 views1 answer
Java sql connection
SQL
0 vote314 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote309 views1 answer
Como hacer un select entre fechas mysql
SQL
1 vote313 views1 answer
How to check the mysql version mac
SQL
2 votes332 views1 answer
How to delete columns in sql
SQL