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

[former_member282800]

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

[Former Member · Accepted solution]

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

[former_member282800 · Accepted solution]

Hi Gopi,

Thanks for the revert.. I have tried the command mentioned below:

1> delete from SAPSR3.USR02 where BNAME='SAP*' and MANDT='200'

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).

I am thinking the owner is SAPSR3, Mark me if I am wrong. Or should the 'owner' be <SID> ?

Please revert back.

Regards,

Neeli Sasank

[Former Member · Accepted solution]

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

[MarioDeFelipe]

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