/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 vote137 views1 answer
Sql inserted
SQL
0 vote137 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote136 views1 answer
Power bi find all ids not in other tables
SQL
0 vote106 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote204 views1 answer
Replace null value within column mysql
SQL
0 vote151 views1 answer
Flexible search query delete table
SQL
11 votes138 views5 answers
How to install sqlite3 python
SQL
0 vote133 views1 answer
Sql check for null and empty string
SQL
0 vote93 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
1 vote144 views1 answer
Mysql list bigger table
SQL