Changes the password for an existing user or for a database.
Syntax
ALTER DATABASE PASSWORD newpasswordoldpassword
ALTER USER user PASSWORD newpasswordoldpassword
The ALTER USER or DATABASE statement has these parts:
Part |
Description |
user |
The name of a user to be added to the workgroup information file. |
newpassword |
The new password to be associated with the specified user or database name. |
oldpassword |
The existing password to be associated with the specified user or group name. |