Changing passwords

All users can change their passwords at any time using sp_password. The System Security Officer can use sp_password to change any user’s password. The syntax is:

sp_password caller_passwd, new_passwd [, loginame]

where:

For example, a user can change his or her own password from “3blindmice” to “2mediumhot” using:

sp_password "3blindmice", "2mediumhot"

These passwords are enclosed in quotes because they begin with numbers.

In the following example, the System Security Officer whose password is “2tomato” changes Victoria’s password to “sesame1”:

sp_password "2tomato", sesame1, victoria