Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 307
  • Last Modified:

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
0
Cha1tu
Asked:
Cha1tu
  • 2
  • 2
2 Solutions
 
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now