/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 vote268 views1 answer
How to to get current date and time in sql
SQL
1 vote269 views10 answers
Stack overflow
SQL
0 vote302 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
9 votes301 views1 answer
Alter table column change data type to text mysql
SQL
1 vote290 views1 answer
Load mysql dumb
SQL
11 votes271 views2 answers
Having clause
SQL
0 vote285 views1 answer
Sqlalchemy case insensitive like
SQL
8 votes301 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
4 votes285 views2 answers
Postgresql reset sequence
SQL
1 vote288 views1 answer
PL SQL MODIFY COLUMN NME
SQL