/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 vote351 views1 answer
Oracle drop type
SQL
0 vote346 views1 answer
Call scalar valued function sql
SQL
1 vote373 views1 answer
Mysql take number in string
SQL
5 votes328 views3 answers
Mysql extract month from date
SQL
0 vote360 views1 answer
Renommer base sql
SQL
0 vote351 views1 answer
Do you know sql
SQL
0 vote347 views1 answer
Adding generated time in row mysql workbench
SQL
2 votes384 views1 answer
How to check if a row is null in sql
SQL
13 votes310 views5 answers
Oracle list tables
SQL
0 vote347 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL