/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 vote346 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote368 views1 answer
C# mysql update statement set value to null
SQL
0 vote346 views1 answer
Low level operator in dbms
SQL
0 vote386 views1 answer
Show all sequences postgres
SQL
14 votes367 views3 answers
Alter foreign key
SQL
0 vote488 views1 answer
Reset a table's identity column and remove test records
SQL
0 vote305 views2 answers
Denormalization in sql
SQL
0 vote387 views2 answers
Generate sql trigger through ef migration
SQL
-1 vote369 views3 answers
SQL to LINQ converter
SQL
0 vote387 views1 answer
Mysql show category once count how many products
SQL