cancel
Showing results for 
Search instead for 
Did you mean: 

All users locked

Former Member
0 Kudos

hi guys,

We abandoned a project for a while and came back to it after sometime. All the users of the DEV server(client 200) were mysteriously locked including all the administrative users(sap*, ddic and the created ones) by God knows who.i cannot log into any of the users to unlock.

ill appreciate ur views on this.

Regards Walata

Accepted Solutions (0)

Answers (2)

Answers (2)

JPReyes
Active Contributor
0 Kudos

In this cases you need to delete SAP* from database using SQL command

Delete from usr02 where bname = 'SAP*' and mandt = '200';

Make sure login/no_automatic_user_sapstar is set to 1

This will let you logon to SAP with user sap* password PASS

Make sure you set login/no_automatic_user_sapstar to 0 after you have successfully created or unlock your user.

Regards

Juan

Former Member
0 Kudos

thanks guys but ive tried this all over again and yet its the same problem...........please help

Regards Walata

JPReyes
Active Contributor
0 Kudos

Well, can you be more explicit?.... what steps did you do and what was the result?

Regards

Juan

PS: You have 6 threads open, can you please review you open threads?

Former Member
0 Kudos

the error i get when i execute the query is

"Invalid Object name usr02"

JPReyes
Active Contributor
0 Kudos

whats your schema?...

try <schema>.usr02

Regards

Juan

Former Member
0 Kudos

try the below command

Delete from SAP<SID>.USR02 where BNAME = 'SAP*' and MANDT = '200';

Only if the DB is oracle.

Regards,

Pavan

Former Member
0 Kudos

my schema is DEV. database is SQL server..............problem persist

Former Member
0 Kudos

thanks guys........problem solved

Regards Walata

JPReyes
Active Contributor
0 Kudos

Can you please close the thread as per the Rules of Engagement?

Please note that you have 6 other threads open.

Regards

Juan

Former Member
0 Kudos

firstly delete SAP* from the DB and login to the client with the default password. and then unlock rest of the users.

Regards,

Pavan