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

0 vote139 views1 answer
Open postgresql.conf in centos
SQL
1 vote131 views1 answer
Alphabetical order mysql
SQL
0 vote138 views1 answer
How to delete python anywhere mysql database
SQL
10 votes140 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote134 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote144 views1 answer
Import Data in MySQL without using any other software
SQL
2 votes176 views1 answer
Creating a view SQL
SQL
0 vote128 views1 answer
Sequelize postgresql schema
SQL
0 vote144 views1 answer
Sql server for loop
SQL
0 vote136 views2 answers
Mysql select date from datetime
SQL