/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 vote210 views1 answer
How to connect to xampp sql server on windows cmd
SQL
3 votes152 views2 answers
Sql asc
SQL
1 vote165 views1 answer
Oracle list data files
SQL
-1 vote154 views1 answer
Round up and down sql
SQL
5 votes174 views6 answers
Sql foreign key
SQL
0 vote153 views1 answer
Mysql export search results
SQL
3 votes124 views1 answer
Postgresql where current year
SQL
1 vote145 views4 answers
Between vs in sql
SQL
0 vote150 views1 answer
Show the colums of table sql
SQL
-1 vote155 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL