ALTER USER or DATABASE Statement (Microsoft Jet SQL)

Microsoft Jet SQL Reference

ALTER USER or DATABASE Statement

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.

See Also
ADD USER Statement CREATE USER or GROUP Statement
ALTER TABLE Statement CREATE VIEW Statement
CONSTRAINT Clause DROP Statement
CREATE INDEX Statement DROP USER or GROUP Statement
CREATE PROCEDURE Statement GRANT Statement
CREATE TABLE Statement REVOKE Statement