Changing passwords for a Sybase user is a fairly straightforward process. The first example deals with changing the “sa” password (privilege user) or another user's password. The second example is when a user changes their password. Here is the syntax.
Note: If your password string begins with a number, enclose it in "quotes."
# isql -
1> sp_password old_password, new_password, sa
2> go
Changing another user's password
# isql -
1> sp_password old_password, new_password, esofthub
2> go
Any user can change their own password
# isql -Uesofthub -Pesofthub_password
1> sp_password old password, new_password
2> go
5 comments:
Your blog is excellent!
Please, send me the photo of your keyring and the link of your blog,
I'll publish in my blog!
Thank you
My email: nicekeyrings@gmail.com
Also remember if you have certain special characters in your password you will need to use quotes to wrap it.
i.e.
sp_password old_password,"NewP^ssw.0rd"
Thanks for the tip Brian.
If you are the sa then the format is:
sp_password sa_password new_password username
Cheers.
Is there any way to find the object sp_password in sybase is used for own password reset or processed a password reset request from any user?
Post a Comment