Thursday, 14 February 2013

Unlock DDIC and SAP* at DB level

Some time we(Basis administrator) may need to unlock or lock DDIC and SAP* at database level.

Please use the following query.
  1. Login to the corresponding DB with username and password or windows authentication if its windows system.
  2. Start a new query or use sql command prompt
  3. Update <SID> .USR02 set UFLAG ='00' where MANDT = '000' and BNAME = 'DDIC';
  4. To display all usernames in the client use the below query
  5. SELECT * FROM <SID>.USR02 where MANDT = '000';
Above procedure is applicable for SAP* too.
at

2 comments:

  1. Unknown6 March 2013 at 10:46

    Hi,
    Sap* one is incorrect.
    Sap* is a kernel user and the parameter in default profile needs to be set to 0 and the user needs to be deleted if it exists in the usr02 tables for the respective client
    Thanks,
    Jayesh

    ReplyDelete
  2. Radhakrishnan7 March 2013 at 18:15

    Hi Jayesh,

    Above procedure is applicable for unlocking a username at DB level not to login
    there is no need to delete usernames sap* until you done know the password

    Cheers,

    ReplyDelete

Note: only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)