ALTER USER or DATABASE Statement

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.



Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×