hana SAP<SID> lock issue

[former_member265210]

Hello,

• We have ABAP on HANA system.
• We are using SAP<SID> user as a DEFAULT user ( i.e ABAP WorkProcess connects to HANA DB using SAP<SID> user for read & write operation to the DB)
• In password policy, we have set the parameter INVALID_CONNECT_ATTEMPTS to 6.

• Issue : For some reason our, SAP<SID> user is frquently locked.. we are in a process to figure this out by auditing...
• My question/requirement :

if the "INVALID_CONNECT_ATTEMPTS"  for the user SAP<SID> reaches to 5, i should get a e-mail notification so that i can reset

the 'INVALID_CONNECT_ATTEMPTS'  value to 0.

how to achieve this?

Regards,

Shridhar Gowda

[former_member182967]

Hi Shiridhar,

As far as I know, currently it can be done (Alert email does not includ checking invalid logon attempt).

You'd better find the root cause and fix it as per note 1855211 - Technical database user is repeatedly locked.

Regards,

Ning

[former_member265210]

Hello Ning,

i have already checked the note:1855211.. with this we can find the which connection is causing the problem.

my question is

if the 'INVALID_CONNECT_ATTEMPTS'  for the SAP<SID> reaches to 5 , i should get a mail notification.. how to do this ?

Regards, Shridhar Gowda

[former_member182967]

Hi Shridhar,

Sorry for my writing error, as far as I know, currently it can not be done (Alert email does not include checking invalid logon attempt).

Regards,

Ning

[jitendra_kumar01]

Hi Sridhar,

Go through this link it would help.

https://help.sap.com/saphelp_hanaplatform/helpdata/en/61/662e3032ad4f8dbdb5063a21a7d706/content.htm

regards

Jitendra