/SQL/Oracle list invalid password logon denied

Oracle list invalid password logon denied

-- 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 vote119 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
8 votes128 views2 answers
Grant all privileges database postgres to user
SQL
0 vote112 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote113 views4 answers
Best data type to represent money in mysql
SQL
0 vote114 views1 answer
SQL column name Oracle
SQL
0 vote187 views1 answer
Mysql update all record removing 2 hours from column
SQL
3 votes110 views1 answer
Oracle list user grants
SQL
0 vote118 views1 answer
Mysql milliseconds
SQL
0 vote138 views1 answer
Sql today at midnight
SQL
1 vote119 views1 answer
Rails run native ssql query
SQL