Skip to Content
avatar image
Former Member

how to unlock Account

in our QAS 000 client we forgot the password for SAP* , DDIC and one jeneric id.

now the account was locked. please help how to reset SAP * this account.

thanks in advance.



Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Apr 01, 2008 at 06:57 AM


    In Profile file, make parameter login/no_automatic usersapstar to 1 and restart SAP for it to take effect.

    Then at SQL prompt, delete user SAP* from table USR02.

    Now login to SAP with user as SAP* and pasword as PASS



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Try this:

      You can replace the DDIC user with solution user and try to change uflag value to 0 at sql prompt. It will unlock the solution user also.

      At sql propmt:

      select * from sapsr3.usr02 where bname='sap*' and mandt='000';

      If you got as "0 records selected'.

      means sap* user does not exists in client 000.

      if you are able to login into sap client ( other then 000)

      run RZ10 and edit instance profile and make following entry.

      login/no_automatic_user_sapstar -> 0

      save and activate instance profile. restart sap server.

      Login to client 000 with sap* and password 'pass' and unlock solution user.



      Edited by: Raghavendra Ambati on Apr 1, 2008 1:09 PM

  • avatar image
    Former Member
    Apr 01, 2008 at 07:37 AM


    May I know which OS and DB are using for your system?

    If Oracle DB using then:

    For example-

    SQL> select mandt,bname,uflag from sap<sid>.usr02 where bname like 'DDIC';

    Update uflag value to '0' for unlock by this command:

    SQL>update sap<sid>.usr02 set uflag=0 where mandt='000' and bname like 'DDIC';

    Here sap<sid> refer to 'dbs_ora_schema' value.

    usr02 is table name where all the details of users stored.

    Note: sometimes we may need to restart the system for updating the buffer use TC /$SYNC



    Add comment
    10|10000 characters needed characters exceeded