Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 305
  • 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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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