/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 vote356 views1 answer
Find how many tables in database sql query
SQL
0 vote397 views1 answer
Stratified sampling sql
SQL
0 vote349 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote358 views1 answer
How to get specific salary in sql
SQL
15 votes402 views3 answers
Mysql update add to existing value
SQL
0 vote328 views1 answer
Getting next sequence value jpa postgress
SQL
11 votes334 views2 answers
Import sql file laravel cmd
SQL
0 vote373 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
3 votes391 views1 answer
Postgres count distinct
SQL
1 vote350 views1 answer
Get all db sizes in mysql server
SQL