/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

1 vote366 views1 answer
Sql check roles
SQL
8 votes373 views1 answer
Oracle add datafile to tablespace
SQL
0 vote367 views1 answer
How to print some string in mysql
SQL
0 vote342 views1 answer
Export partttion and import in oracle
SQL
0 vote329 views1 answer
On update current_timestamp jpa
SQL
48 votes403 views3 answers
Psql create database
SQL
1 vote394 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
1 vote343 views2 answers
How to search date in sql query
SQL
0 vote362 views2 answers
Update information in a mysql column
SQL
0 vote358 views1 answer
Mysql subtract month from timestamp
SQL