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

hi i enabled auditing on my database.i want to see the login failures of a user.let me know that.thanks
LVL 2
Cha1tuAsked:
Who is Participating?
 
sdstuberCommented:
look in dba_audit_trail


where ACTION_NAME = LOGON  and returncode != 0
0
 
Cha1tuAuthor Commented:
can we find the users login failues > 5.

how many failure logins >5 ?

0
 
Cha1tuAuthor Commented:
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)
0
 
sdstuberCommented:
select username, count(*) from dba_audit_trail
where ACTION_NAME = LOGON  and returncode != 0
group by username
having count(*) > 5
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.