Pages

▼

Wednesday 15 June 2011

How to activate automatic sap* user in ABAP stack of sap?

This article answers the following queries:
  • Forgot sap login password for ABAP stack . Donot have any other password for any other user id. How to login to sap? 
  • How to activate automatic sap* user in ABAP stack of SAP?
  • Unable to login to newly created client with sap* and default password. How to login now ? 
  • Sap* user got locked for ABAP stack. Donot have any other user id to unlock the same. How to login to system again?

-----------------------------------------------------------------------------------------
  In SAP, there is a parameter login/no_automatic_user_sapstar whose default value is 1. If the value is set to 1, automatic login of sap* into SAP system using password PASS won’t be allowed.
In all of the above scenarios,
Pls set the value of parameter login/no_automatic_user_sapstar to 0 in both the default profile and the instance profile and restart the instance. So automatic login of sap* with default password will be enabled.


How to change SAP parameter ?
Afterwards, connect to the database and execute the following command :
In the following example am considering, oracle as the database.
sqlplus “/ as sysdba”
SQL > Delete from SAPSR3.USR02 where MANDT=’000’ and BNAME=’SAP*’;
In the above command, SAPSR3 is the schema of the database and USR02 is the table name and MANDT is the client and BNAME is the user id.
In case you would like to activate sap* in client 500 and your schema name is SAPBPW then the command would be as below :
SQL > Delete from SAPBPW.USR02 where MANDT=’500’ and BNAME=’SAP*’;
Once you successfully executed this command, you can login to sap system with SAP* user id and default password PASS

Related Links :

at

17 comments:

  1. Atinder A.K.A Kunal1 February 2012 at 11:55

    In IDES 4.7 I deleted sap* user from client"000" using su01 and then tried to login with sap* and password-->"06071992",I couldn't login. so I tried to login this time with password as "pass" and it worked.Then I created sap* user again in the same client(000) and set the password as "06071992",I was able to login but I am not able to run any of the t-codes as i am getting the error that sap* is not authorized to run this transaction. Can you help me out with this ?

    ReplyDelete
    Replies
    1. sudmitra6 March 2012 at 22:31

      Login to 000 with DDIC with password - 19920706.
      Run SU01.
      Edit sap*
      Assign SAP_ALL & SAP_NEW profiles to it.
      Save it & prob resolved.

      Delete
  2. Unknown5 December 2012 at 13:24

    hi durgaprasad,
    i installed ECC6.0 and sap in C drive and oracle in G drive and , sap is working properly , but i am unable to connect with database at os level, please tell me, database sid is yuv

    Thanks and regards,
    malleshera@gmail.com

    ReplyDelete
    Replies
    1. DurgaPrasad19 June 2013 at 18:40

      Hi Mallesh,

      Please let us know the error you are facing so that it would be possible for me to understand the issue.

      Delete
  3. Unknown29 March 2013 at 20:15

    Do we need to bounce the system after we change the parameter?

    ReplyDelete
    Replies
    1. DurgaPrasad19 June 2013 at 18:39

      Hi Satadru, If the parameter is dynamic, no need to bounce. if the parameter you changed is static one, you need to bounce the system for the parameter to take effect.

      Delete
  4. Anonymous23 April 2013 at 02:48

    hello prasad,

    i was unable to login to 000 client with user sap* and ddic, i forgot the password. and i was unable to login to sap* in client 001 but i was able to login into 000 and 001 with user ddic

    ReplyDelete
  5. DurgaPrasad23 April 2013 at 10:46

    Hi..Please follow the recommendations mentioned in the above article. You will be able to login with sap* with pass password.

    ReplyDelete
  6. Anonymous12 September 2013 at 06:29

    Just need to set the parameter as 1, so which profile i need to select, is it default in RZ10

    ReplyDelete
  7. yektek training18 February 2014 at 10:11

    This comment has been removed by the author.

    ReplyDelete
  8. Unknown10 July 2015 at 18:04

    how to delete sap* in os level pls tell me

    ReplyDelete
  9. Unknown21 November 2015 at 14:04

    how can i change these parameter on os level.. i have windows 10

    ReplyDelete
  10. Unknown30 March 2016 at 12:36

    durga prasad ji,
    i am created one new client. but i am trying to login
    username : sap*
    password : pass
    but i am getting wrong username and password ... will u clarify my problem

    ReplyDelete
  11. P Manoj Kumar19 June 2017 at 12:18

    Hi...
    When i try to delete sap* user by using MANDT=000 it is showing like 0 rows updated and 000 client is not visible in existing clients list.
    My database is Oracle 12c. Any solution for that...??

    ReplyDelete
  12. NAVEEN13 October 2017 at 11:18

    Hi Durgaprasad ,

    If i change the parameter for sap* login is that manditory to delte the usr02
    in the login level ??

    ReplyDelete
  13. Unknown5 October 2018 at 23:12

    After setting paramer I was able to login with sap* password . But I couldn't see user neither in Usr02 nor su01 .. can someone explain how we are able to login to system without maintaining the user master record in Usr02 .. and please explain how user is storing in kernal level (as hard coded value)

    ReplyDelete
  14. Unknown25 October 2019 at 12:21

    These topics are very helpful for the beginners and kindly try to upload recent activities if possible this will helpful....

    ReplyDelete

Please provide your valuable feedback: