/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 vote260 views1 answer
Search In the Database using Text
SQL
0 vote241 views1 answer
Access refused mysql xampp server
SQL
0 vote285 views1 answer
Postgre query date
SQL
1 vote264 views1 answer
Oracle difference between two dates in years
SQL
0 vote265 views1 answer
Postgresql la fonction dblink_connect(unknown, unknown) n'existe pas
SQL
12 votes233 views4 answers
SQL Where
SQL
0 vote266 views1 answer
Search mysql database for column
SQL
0 vote257 views1 answer
Make a socket server to detect changes in mysql
SQL
6 votes280 views2 answers
Mysql 1 day ago
SQL
0 vote245 views1 answer
How to query all tables mysql at the same time
SQL