Oracle detect invalid password

-- 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 votes97 views2 answers
Postgres update single column
SQL
24 votes108 views5 answers
Sql server insert into select
SQL
2 votes67 views1 answer
Foreign key example in dbms
SQL
0 vote112 views3 answers
Database restoring error
SQL
0 vote138 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL
0 vote155 views1 answer
Osm2pgsql mac
SQL
1 vote119 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote127 views1 answer
Python dictionary to sql update
SQL
1 vote106 views1 answer
How much every mysql database record takes from diskspace
SQL
25 votes108 views3 answers
How to use a database to see tables mysql
SQL