/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

4 votes331 views1 answer
Describe table mysql
SQL
0 vote317 views1 answer
Json_remove mysql
SQL
0 vote328 views1 answer
Mysql table variables
SQL
8 votes344 views1 answer
Today minus 15 days postgresql
SQL
0 vote333 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote449 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
1 vote335 views1 answer
SQL date part only of datetime
SQL
0 vote331 views1 answer
Oracle current session details
SQL
1 vote345 views1 answer
Oracle create_program
SQL
-1 vote362 views5 answers
Not in sql
SQL