SAP* locked in new client

[Former Member]

Hi Friends,

In ECC 6.0 i have created a new client and due to no of wrong attempts SAP* user is locked, no other userid other then sap* is created in that client.

Now how can i login? Please help me.

Thanks

Naren

[Former Member]

Hi Krishna,

Please check note: 412258.

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=412258

it will solve your issue.

Regards,

Mahendra

[Former Member]

Hi Mahendra,

I have not implemented it yet as it is asking for a developer's key but thanks for your prompt reply. We may take time to implement the report in the system. (How can i give you points ?)

Regards,

Krishna.

[Former Member]

Hi Krishna,

You can not view since you deleted the one.

you can create that using su01 t-code.

Regards,

Mahendra

[Former Member]

Hi Mahendra,

I cant create the user in SU01, it is throwing a run-time error:

http://rapidshare.com/files/408341119/t1.htm

Any ideas now? (Our SAP_BASIS: 701, Patch 6)

Many Thanks,

Krishna.

[Former Member]

I had this problem with Solution Manager 4.0 SR1 and like i've said try this it should work without a doubt. sap* is automatically locked in the newer systems and you have to unlock it first to be able to login using sap*

what you need to do is log on to your Operating system and change the Default Pfofile parameter in /sapmnt/<SID>/profile

change login/no_automatic_login_sapstar from 1 to 0 then you'll be able to login using sap* and password pass.

please reward for helpful answers

[Former Member]

Hi,

what you need to do is log on to your Operating system and change the Default Pfofile parameter in /sapmnt/<SID>/profile

change login/no_automatic_login_sapstar from 1 to 0 then you'll be able to login using sap* and password pass.

please reward for helpful answers

[JPReyes]

Once you have change the parameter and deleted the user....

logon as sap*

password: pass

Hope this help

Juan

[Former Member]

Hi Juan Reyes,

As u said, I have deleted the user from DB level and now, iam able to login in the new client with standard password: pass .

Now, the problem is iam not able to view the sap* user under SU01. At DB Level, i checked it whether it has been created again or not: select bname from SAPSR3.usr02 where mandt='001'; but it is not created. How to solve this problem now?

Thanks in advance,

Krishna.

[Former Member]

Hi,

have you ever did any client copy on this client if so you can use that client user atleast ddic user if not.

from netwear 2004s login/no_automatic_user_sapstart = parameter was set to 1 goto RZ10 and change the value to 0

and

in backend i.e, in SQL promt execute

update USR02 set UFLAG = 0 where MANDT = <client number> and BNAME=SAP*;

Samrat

[Former Member]

Hi,

when i try to excute the given command for deletion of user SAP*

it says USR02 table does not exist's, Please let me know where i am doing wrong.

when i enter into the ECC 6.0 (oracle 10.2) as oraSID and

sqlplus '/as sysdba'

SQL> SELECT * FROM USR02

2 ;

SELECT * FROM USR02

*

ERROR at line 1:

ORA-00942: table or view does not exist

SQL> DESC USR02;

ERROR:

ORA-04043: object USR02 does not exist

Please help me in detail.

Thanks

Naren

[Former Member]

Use the <schema_name> before the table name you are trying to access.

SELECT * FROM <schema_name>.USR02;

eg.

SELECT * FROM sapr3.USR02

[Former Member]

Hi Kesarker,

Thanks for the reply but

SQL> select * from sapr3.USR02;

SP2-0734: unknown command beginning "select ..." - rest of line ignored.

can you please help me in finding the name of the schema used in ECC 6.0??

thanks

Naren

[Former Member]

Use SAP<SID> before the table name you are trying to access.

SELECT * FROM SAP<SID>.USR02;

eg.

DESC SAPBWP.USR02;

SELECT * FROM SAPBWP.USR02;

[Former Member]

Hi Naren,

You need to set the profile parameter "login/no_automatic_user_sapstart = 0 " by logging to a working client. (save and acitvate this Instance profile)

and execute the following query at SQL prompt..

delete from <HOSTNAME>.<SID>.<sid>.USR02 where BNAME='sap*' and MANDT=<new client>;

down the instance and bring it up and try login as SAP* with password PASS.

hope this helps!

with regards,

raj.

<i>pls, award points.</i>