In SAP there is 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.


1. 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.


2. Connect to the database and execute the following command.

          sqlplus “/as sysdba”


SQL> Delete from SAPSR3.USR02 where MANDT='<Client>’ 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.


Example: In case we would like to activate sap* in Client 300 and our schema is SAPBPW then the command would be as below.

SQL> Delete from SAPSR3.USR02 where MANDT=’300′ and BNAME=’SAP*’;


Once we successfully executed this command, we can login to SAP System with sap* user ID and default password PASS.


To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply