on 09-15-2010 10:03 AM
Hello,
Could anyone tell me how I can count or see the failed logon_attempts for a specific user in sql (Oracle)?
In this case the SAPSID user.
I already know how to unlock users and how to set the FAILED_LOGIN_ATTEMPTS to unlimited.
Could someone help me?
Kind regards,
Marcel
I'm seaching for a sql-statement in oracle 10. So that I don't have to stop de database.
This value should somewhere be kept in some kind of table.
Regards,
MArcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!
You need to activate audit in Your db. This is not default in 11.2, but default in 11g bases.
Check if the parameter audit_trail in your db are set (show parameter audit_trail )
If not set; alter system set audit_trail='DB' scope=spfile or set audit_trail=DB if you use pfile. Bounce your database.
Then you need to audit logins: audit create session;
After this, you can ask on e.g. dba_audit_trail and look for returncode!=0
Regards
Audun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.