/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

3 votes344 views1 answer
Créer une table sql
SQL
1 vote345 views1 answer
Drush sql-dump
SQL
5 votes300 views1 answer
Postgres upsert
SQL
0 vote374 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote354 views1 answer
Mssql dockere
SQL
0 vote344 views1 answer
VSCode SQL Server Connection error
SQL
15 votes347 views5 answers
Show tables in oracle
SQL
0 vote308 views1 answer
Sql runnignsum
SQL
0 vote333 views1 answer
Syntax for changing column size in mysql
SQL
6 votes408 views2 answers
Oracle undotbs usage
SQL