topic Re: Cannot get into additional client(not golden client) in Application Development and Automation Discussions

Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 12:07:31 GMT

We have the golden client 200 and an additional client 600. In production seems that everyone who has access to unlock and change passwords has forgotten and locked their accounts including myself. This is because most of us rarely go into this client.

Can anyone suggest a process for me (admin) to unlock and get in? maybe thru the backend (sql 2005)

Thanks so much!

maria

Re: Cannot get into additional client(not golden client)

Former Member — Wed, 16 Mar 2011 12:28:51 GMT

Hi,

you can delete entry for SAP* from USR02 table (through database tools) and then log in with user SAP* and default password PASS. Be careful, delete only entry for client in which you want to log in. Please, remember - profile parameter login/no_automatic_user_sapstar = 0 must be set in default.pfl for logon with SAP*.

Re: Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 12:46:11 GMT

I think you missed the point here the issue is not with client 000, but client 600

maria

Re: Cannot get into additional client(not golden client)

markus_doehr2 — Wed, 16 Mar 2011 12:56:59 GMT

> I think you missed the point here the issue is not with client 000, but client 600

doesn't make a difference.

delete from usr02 where bname = 'SAP*' and mandt = 600

Then login to client 600 using SAP* and 'pass' as password. However, this works only if the parameter already mentioned is set.

Markus

Re: Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 12:58:43 GMT

oh, did'nt realize I could do that there as well!

Re: Cannot get into additional client(not golden client)

Former Member — Wed, 16 Mar 2011 13:00:31 GMT

This is actual for any client.

Just delete one entry for MANDT=600 and BNAME=SAP* from USR02 table and log in with password PASS.

Re: Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 13:01:19 GMT

the param is set to 0 as you indicated, however do we have to bounce the system at all? or just remove the entry from usr02?

Re: Cannot get into additional client(not golden client)

markus_doehr2 — Wed, 16 Mar 2011 13:04:02 GMT

The deletion must be done anyway.

You can only login with SAP* and pass if the parameter is set to 1. Otherwise the system refuses the logon.

Markus

Re: Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 13:08:30 GMT

Awesome I'm in and unlocked! thanks so much, so simple, but didn't realize about doing this for all clients, sometimes the brain takes mini vacations!

Re: Cannot get into additional client(not golden client)

MPGraziano — Wed, 16 Mar 2011 13:11:32 GMT

MMMM, but it worked? maybe should be set to 0?

Re: Cannot get into additional client(not golden client)

Former Member — Wed, 16 Mar 2011 13:12:42 GMT

For additional information about SAP*, check:

https://service.sap.com/sap/support/notes/2383

https://service.sap.com/sap/support/notes/68048