DDIC and SAP* user locked

[Former Member]

hello sir,

i have problem in login with user ddic and sap. Both the users are locked.how can i unlock the ddic and sap user.

i also have another user but it does'nt have any authorization.then how can i login plz help me sir.

[Former Member]

It is possible to unlock the user via SQL call and without deleting SAP*

(If you have forgotten the passwords, you have to delete the user SAP* etc)

- login to the server via mstsc as user <sid>adm.

- start sql server management studio

- press "Connect"

- press "New Query"

- enter this commands and press F5 afterwards:

use <SID>

go

setuser '<sid>'

go

update table USR02 set UFLAG=0 where MANDT='<your_client>' and BNAME='DDIC'

- if you want to unlock another user, you can use the same query window,

but then the following is enough as commands:

update table USR02 set UFLAG=0 where MANDT='<your_client>' and BNAME='<your_user_name>'

[former_member189546]

Hello,

Please, check the below thread,

Unlock SAP*

regards,

John Feely