/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

1 vote315 views1 answer
Oracle duration between timestamps
SQL
0 vote327 views1 answer
Cross apply top for each row t1
SQL
0 vote291 views1 answer
Sql from null to not null
SQL
6 votes365 views2 answers
How to get last element sql
SQL
0 vote303 views1 answer
Update if else mysql
SQL
2 votes354 views1 answer
Oracle Column Names of a table
SQL
0 vote334 views1 answer
Postegresql update to null
SQL
0 vote328 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote328 views1 answer
What does leave do in mysql
SQL
0 vote343 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL