Logon attempts oracle

[Former Member]

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

[Former Member]

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

[audunlea_hansen]

shouold, yes, but are not if you not have activated the function or made some logic with logon-trigger.

I've worked with Oracle databases for 13 years.. So as long you not have upgraded til 11.2.0 you are not logging this info in the database by default.

Regards

Audun

[audunlea_hansen]

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