sap solman resting password of sap* in sybase database

[akram_mg0]

i logged on sybase database , and followed those steps:

isql -Usapa -SSID -w2000

pwd:

use SID

go

and the to command select but i faced this massage :

Msg 10330, Level 14, State 1: Server 'SOL', Line 1: SELECT permission denied on object USR02, database SOL, owner SAPSR3

[kaus19d]

Hi akram_mg0,

Are you sure that you have a seperate "sapa" User, because I see that you are trying to login instead of using User "sapsa" in the isql command

In case, you have a similar user to sapsa, to would need adjust the permissions & details as per SAP Note: 2143485, 2436325

As alternative you can also reset sapsa via sapsso User, if you have as per SAP Note: 1602547

for SAPSR3 login, you can try by using below, but it depends whether you have that User in your dba, i mean for java system it would be SAPSR3DB

isql -USAPSR3 -S<SID> -x -P<password>

Thanks,

Kaushik

[akram_mg0]

hello kaushik,

thanks for answering i already solved this incedint i used user SAPSA bu the frist time i was trying a wronge password but i new the correct one .

also this document was very usful thansk alot

akram gamal