Skip to Content

Reset SAP* for Client 200 (not 000) at Sybase db level

Hi All,

I am trying to reset the password for SAP* in Client 200, I am unable to login through SAP*.

Please guide me with the commands and steps to reset the password for the same. I need to get this done ASAP.

Following is the error that comes in when I am trying to delete the entry from the USR02 table:

1> delete from SAPSR3.usr02 where MANDT='000' and BNAME='SAP*'

2> go

Msg 208, Level 16, State 1:

Server 'HR3', Line 1:

SAPSR3.usr02 not found. Specify owner.objectname or use sp_help to check whether

the object exists (sp_help may produce lots of output).

Kindly revert back. Points will be awarded.

Regards,

Neeli Sasank

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 03:01 PM

    Hi Sasank,

    Try these steps:

    isql -Usapa -SSID -w2000

    pwd:

    use SID

    go

    Select top 1 * from owner.USR02

    go

    Select * from owner.USR02 where BNAME= 'user' and MANDT='client'

    go

    delete from owner.USR02 where BNAME='user' and MANDT='client'

    go

    restart SAP and try once.

    Regards,

    Gopi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Sasank Neeli

      Hi Neeli

      In SAP system, from menu bar choose system -->status

      in the right hand bottom corner you will get the owner name. This is to verify the schema name of the table.

      You can also execute

      To filter by database and owner / schema for tables only, for example, master and dbo:

      exec sp_tables '%', 'dbo', 'master', "'TABLE'"


      Regards

      Prithviraj

  • Posted on Jul 21, 2016 at 01:08 PM

    Hello

    Sybase doesn't have default databases/schemas. Instead it uses login policies. Each database has a login policy assigned to it, so assumed you are logged correctly you dont need to specify schema.

    the command you are pasting is more oriented to Oracle.

    DELETE FROM USR02 WHERE BNAME = 'SAP*' and MANDT = '200'

    dont forget to set profile parameter

    login/no_automatic_user_sapstar = 0

    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.