/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 vote141 views1 answer
Select statement to print longest name
SQL
0 vote195 views1 answer
Mysql show schema
SQL
0 vote111 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote152 views1 answer
Max mysql
SQL
3 votes164 views1 answer
Postgres select max value
SQL
0 vote146 views1 answer
How to use sqlcommand
SQL
2 votes202 views3 answers
3 days back in sql server
SQL
0 vote160 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
1 vote188 views1 answer
Oracle drop chain step
SQL
10 votes144 views1 answer
Create table oracle
SQL