How to reset/change login password in sybase

To reset/change the login password follow the below steps:

This is process is generic to change login password for named logins as well as sa login.

For sa login password change we need sapsso login ,for named logins we can use sa account .

Logon to isql session with sapsso login to change sa password :

isql -S<SID> -Usapsso -P<sapsso_password> -X -w9999

SID : sybase instance name which you can find by entering the showserver command in os level.


Syntax :

sp_password caller_passwd, new_passwd , loginame, immediate

go

caller_passwd : current login user password

new_passwd : new password which you want to give

Login name : specify the login name which you wanted change the password



use master

go

alter login sa with password “<sapsso_password>” modify password “<new_sa_password>”

go

OR 

sp_password caller_passwd, new_passwd,sa

go


NOTE : if you are not specifying the login name ,password will set for the current active login.


Refer the sybase info center for more info

https://infocenter-archive.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1502/html/sprocs/X96621.htm


Related topic:

https://infosybase.blogspot.com/2020/07/how-to-recover-sasapsso-password-in.html

Sybase history

Sybase  is a computer software company that develops and sells database management system (DBMS) and middleware products. The company was fo...