on 04-28-2008 9:21 AM
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
Thanks,
It's work fine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry but I am not able to connect in MANDT 000
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.