cancel
Showing results for 
Search instead for 
Did you mean: 

DDIC user blocked in MANDT 000

Former Member
0 Kudos

Hi all,

How to unlock the DDIC user in the MSSQL Server like a procedure in Oracle databse : Update sapr3.usr02 set UFLAG=0 where BNAME='DDIC' and MANDT='000'

Thanks

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Thanks,

It's work fine

Former Member
0 Kudos

Sorry but I am not able to connect in MANDT 000

Thanks

Former Member
0 Kudos

Hi,

if you still execute query at OS level

run query analyzer if you use SQl server 2000

or run sql server management studio if you use SQL 2005

use folloiwng query

in SQL 2005 click on new query

USE SID

Update sid.USR02 set UFLAG=0 where BNAME='DDIC' and MANDT='000'

where SID = your sap system id ID in uppercase

sid = your sap system id ID in lowercase

query are case sensitive

regards,

kaushal

Former Member
0 Kudos

Hi,

if you are able to login into client 000 using different user then ddic then login with that user and unlock DDIC user from 000 client using SU01 tcode

use SAP* user to login into 000 client.

regards,

kaushal