ACS Stored Procedures for Password Changes

Since ACS runs many Sybase SQL servers we needed a method of changing a password across all of the servers instead of forcing the user to change each server password or worse yet, maintaining many sets of user logins with many different passwords. sp_acs_password uses the cerebus addition to our Openserver server to change a user's password on all of our Sybase SQL servers simultaneously.

The synopsis is:

sp_acs_password <old-password>,<new-password>

messages will be printed regarding the state of the password change.

This is important because the Sybase Transact-SQL documentation will refer you to sp_password, but in our environment you will not have the authority to execute sp_password. Hence you must use sp_acs_password.

Last Modified September 25, 1996 - Lou Williams