Activating Automatic sap* user

[Former Member]

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.