Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
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.

1 Comment
Labels in this area