cancel
Showing results for 
Search instead for 
Did you mean: 

Unlock sap* with sybase database mixed windows server 2012

anderson_cardozo
Participant
0 Kudos

Hi Sap gurus,

I enabled the profile parameter login/no_automatic_sapstar, but the message show me "password logon no longer possible, too many failed attemps" when write sap* and password pass, in client 000.

How can I unlock this user?

My database is Sybase with windows server 2012


Best regads.

Accepted Solutions (0)

Answers (3)

Answers (3)

Sriram2009
Active Contributor
0 Kudos

Hi Anderson

Check this SCN thread How to unlock DDIC & SAP* user in 000 clien... | SCN

Regards

SS

Former Member
0 Kudos

Hello Anderson,

Login with sapsa on OS level

isql -S<SID> -Usapsa -P<PASSWORD> -X

1> use SID

2> go

1> select top 1 * from SAPSR3.USR02

2>go

1>select * from SAPSR3.USR02 where BNAME='SAP*'

2>go

1> delete from SAPSR3.USR02 where BNAME='SAP*'

2> go

Let me know if this works.

Regards

Anand

former_member187136
Contributor
0 Kudos

Hi Anderson,

Log in with another User, with same roles and Unlock the user.

Use SU01 t-code to Unlock it.

Regards

Kiran K Adharapuram