Changes the password for an existing user or for a database.
Syntax
ALTER DATABASE PASSWORD newpassword oldpassword
ALTER USER user PASSWORD newpassword oldpassword
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. |
