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 vote120 views1 answer
Mysql select all table that have field names
SQL
2 votes123 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote138 views1 answer
Drop column from table if exist on live server mysql
SQL
0 vote118 views1 answer
VSCode SQL Server Connection error
SQL
0 vote185 views1 answer
Import sql dump into postgresql database
SQL
0 vote136 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote126 views1 answer
How to use sqlcommand
SQL
1 vote132 views1 answer
Error code 1292 mysql workbench
SQL
5 votes117 views2 answers
Postgres update with if condition query
SQL
3 votes244 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL