cancel
Showing results for 
Search instead for 
Did you mean: 

SAP* user locked

Former Member
0 Kudos

Dear All,

I am finding it difficult to login with 000 client with SAP*.

My colleague had deleted the records from usr02, 03 table. Can login with other client.

I have read about the updation of flag and then deletion from usr02. But usr02 table does not have records for SAP* and mandt=000.

Also the profile for login/....sapstar=0 is not defined, so nothing to restart.....

Is there anything I am missing ?

Regards

Pras

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi All,

I could manage to get into client 000 with SAP* with the steps you all mentioned. But I have a problem there. After I login, I could not run any transaction. Its saying no authorization...

Also I have changed the parameter now and next day I could not login to another client with SAP. I could not see any records in usr02 for SAP

Please suggest

Former Member
0 Kudos

Hi,

you are login with sap* and password pass in to client 000.

now when you run any tcode it's says not authorized !!!!

which tcode you execute?

regards,

kaushal

Former Member
0 Kudos

Hi Kaushal,

Not a single transaction works?

Regards

Prashant

Former Member
0 Kudos

Hi,

it's strange!!!!

try to restart sap server.

regards,

kaushal

Former Member
0 Kudos

> I am finding it difficult to login with 000 client with SAP*.

>

Can you login to 000 with DDIC, if so copy DDIC to SAP* through SU01.

> My colleague had deleted the records from usr02, 03 table. Can login with other client.

Did you mean all the records in the USR02/03, that sounds dangerous, before you exit out, make sure you create a user with profile SAP_ALL and SAP_NEW

markus_doehr2
Active Contributor
0 Kudos

- login as ora<SID>

- sqlplus /@<SID>

- delete from usr02 where bname = 'SAP*' and mandt = <client>

- set "login/no_automatic_user_sapstar = 0" in your instance profile

- restart the server

- login

Markus

Former Member
0 Kudos

Thanks Markus, I could login in now.

Also one doubt for another client that was created, I could not login with SAP*.

table usr02 doesnot contains any entry...

Former Member
0 Kudos

Hi,

set login/no_automatic_user_sapstar = 0 in your instance profile using tcode RZ10

save the instance profile and activate it.

restart sap server.

now login with sap* and password 'pass'

regards,

kaushal

Former Member
0 Kudos

Which Version do you have?

The default Value of login/no_automatic_user_sapstar was changed.

I have seen Netweaver 2004s based Systems, where you have to set the parameter to aktivate sap* with the known password after writing to usr02.