/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 vote388 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote355 views1 answer
Get employees if not contains in sql
SQL
3 votes368 views1 answer
Null sql
SQL
-1 vote340 views1 answer
Sql syntax create timestamp column
SQL
0 vote383 views1 answer
Ajouter une clé etrangere mysql
SQL
1 vote388 views1 answer
Mysql count all table rows
SQL
1 vote351 views1 answer
Mysql batch insert
SQL
1 vote329 views1 answer
Reutrn string after character sql
SQL
1 vote402 views1 answer
Oracle create program if not exists
SQL
1 vote368 views1 answer
Mariadb case switch
SQL