Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

how do i find the login failuers of an user in the auditing?

Posted on 2011-03-24
Last Modified: 2012-05-11
hi i enabled auditing on my database.i want to see the login failures of a user.let me know that.thanks
Question by:Cha1tu
  • 2
  • 2
LVL 74

Accepted Solution

sdstuber earned 500 total points
ID: 35209476
look in dba_audit_trail

where ACTION_NAME = LOGON  and returncode != 0

Author Comment

ID: 35384049
can we find the users login failues > 5.

how many failure logins >5 ?


Author Comment

ID: 35384193
I would like to know if there is any way we can find out the number of login failures of a user. If we can find out, I am interested in filtering out those users whose login failures were greater than 5 and their number of failures(count of failures)
LVL 74

Assisted Solution

sdstuber earned 500 total points
ID: 35388025
select username, count(*) from dba_audit_trail
where ACTION_NAME = LOGON  and returncode != 0
group by username
having count(*) > 5

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL Display based on value 4 39
Distinct values from all columns in a table?? PL SQL 4 48
PL/SQL Two changes 7 34
Oracle Nested table uses ? 2 28
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question