Activating Automatic sap* user
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.