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

18 votes164 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote193 views1 answer
Mysql disable query caching
SQL
0 vote226 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote222 views1 answer
Search starting with mysql
SQL
0 vote206 views1 answer
Sql stored procedure update if parameter is not null
SQL
18 votes213 views6 answers
Mysql create table
SQL
0 vote196 views1 answer
Create a view in sqlite
SQL
0 vote228 views1 answer
How to find lowest in sql
SQL
0 vote232 views1 answer
When mysql server would not work in xampp
SQL
0 vote252 views1 answer
Plsql check for string in numeric
SQL