Skip to Content
author's profile photo Former Member
Former Member

Problems with the sap* password

Hi,

i have a problem with the sap* password.

I tried my masterpassword but it did not work.

So i tired the following from the Tread: Password problem with user DDIC

-


resetting password for sap*

sqlplus "/as sysdba"

sql> update sapsr3.usr02 set bname='SAP1' where bname='SAP' and MANDT=000;

sql> commit;

-


Bud it did not work. After i tried to delete the sap*1 from the table sapsr3.usr02 but it did not work.

sql>delete from sapsr3.usr02 where mandt='000' and bname = 'SAP*1';

-


I also restarted the instance after the commands. But i can not logon with 'sap*' and the password 'pass' .

Mybe someone can help me?

Regards

Mike

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 07, 2008 at 08:17 PM

    Starting with release 7.00 based system you have to set

    login/no_automatic_user_sapstart=0

    in your instance profile and restart the instance.

    Markus

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2008 at 09:57 AM

    It works!

    Thank you Markus!

    Regards Mike

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.