unlock sap* and DDIC user

[Former Member]

hi

Working on NW7.0 EHP1. User DDIC and SAP* is locked in 000 and 001.

how to unlock it in SQLSERVER level.

I changed automatic_sap =0 in default.PPL profile already.

I tried executing below command in SQL Server -> New Query Analyser at same time. it gives error

update nwa.USR02 set UFLAG=0 where BNAME='SAP*' and MANDT=' 000';

Commit;

so can you please confirm?

input for BNAME is SAP or SAP* ?

Also Commit statement is giving error, does anybody know how to give commit.

Is it commit work; or commit transaction;

I gave both update and Commit statement at once and compilted executed.

Any body knows how to commit and execute command to

regards

[Former Member · Accepted solution]

Hi Jai,

 input for BNAME is SAP or SAP* ?

BNAME will be SAP*

 Is it commit work; or commit transaction; 

Execute the command with out commit

Regards

Ashok Dalai

[Former Member · Accepted solution]

hi ashok

yes i executed the command and restarted SAP.

should i have to give SAP* and PASS (upper case or lowercase to login)

please confirm.

regards

[Former Member · Accepted solution]

Yes Sir.

The password pass will not work because you just have unlocked the user by setting u flag to 0.You should login with the old password for sap*.

If you do not remember the password then delete user sap* and login as sap* and password pass.

Regards

Ashok Dalai

Edited by: Ashok Dalai on Jul 23, 2009 9:19 AM

[Former Member]

Hi

UPDATE SAP<SID>.USR02 SET UFLAG = 0 WHERE MANDT = "<client number" AND

BNAME = "<your user ID>"

UFLAG - means your lock mode <..0,64,128...>

MANDT - you client

BNAME - your user name

If you want to delete the user sap* then follow below steps

Open Microsoft SQL Server Managment studio.

login with <SAPSID>adm user.

click on new query.

execute below query.

delete from <sapsid>.USR02 where BNAME='SAP*' and MANDT='800'

bounce the server for paramter to take effect then try with sap* and pass

SAPSR3 would be your schemaid

Regards

Uday

[Former Member]

hi all

solved the problem. i had problem with executing command in SQL however finally got it.

thanks for all support

regards

[Former Member]

I changed automatic_sap =0 in default.PPL profile already.

The parameter name is login/no_automatic_user_sapstar Check following link for more info.

[http://help.sap.com/saphelp_45b/helpdata/en/52/671792439b11d1896f0000e8322d00/content.htm]