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

How to reset SAP* user in BW on HANA system

Hello

The license on BW on HANA system has expired and we want to use SAP* user to login to system and install new license.

My question is how can I reset SAP* user if the user is locked due to too many failed logon attempts?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2013 at 08:07 AM

    Hello Jack,

    the table USR02 typically isn't buffered any more, so that change should be simple. Log on to the HANA server as sidadm.

    hdbsql -i $$ -u SAPSR3 -p password_of_sapsr3

    ($$ is the instance number of the HANA database)

    hdbsql=> update usr02 set uflag=0 where mandt='000' and bname='SAP*'


    Regards,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 16, 2013 at 08:25 PM

    Hi all,

    you can also delete SAP* (bname) user from table USR02 using SQL command in HANA Studio, given the fact that SAP* user is hardcoded, it will regenerated and you can logon with 06071992.

    I have checked this on our system the Schema is SAP<SID> as mentioned by Srinivas. You have to make sure that you have appropriate rights to change tables in SAP BW schema.

    Best Regards,

    Marcel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 23, 2013 at 11:23 PM

    Hello, Thanks to all your replies.

    Using SAP HANA Studio SQL editor as the schema owner SAP<SID and running the standard SAP* delete sql statement worked fine.

    Thank you

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2016 at 10:54 PM

    This message was moderated.

    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.