/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 vote222 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote200 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
19 votes217 views6 answers
Create table sqlite
SQL
22 votes205 views3 answers
Remove all records from table mysql
SQL
1 vote186 views1 answer
Oracle create program if no exists
SQL
1 vote165 views1 answer
Foreign key in oracle sql developer
SQL
1 vote186 views1 answer
Sql delete all values in a column
SQL
0 vote197 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
0 vote211 views1 answer
Allow null in psql
SQL
0 vote205 views1 answer
Sql server change schema of a table
SQL