Export (0) Print
Expand All

ALTER USER or DATABASE Statement (Microsoft Access SQL)

Office 2007

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:

PartDescription
userThe name of a user to be added to the workgroup information file.
newpasswordThe new password to be associated with the specified user or database name.
oldpasswordThe existing password to be associated with the specified user or group name.
See Also

ADD USER Statement

ALTER TABLE Statement

CONSTRAINT Clause

CREATE INDEX Statement

CREATE PROCEDURE Statement

CREATE TABLE Statement

CREATE USER or GROUP Statement

CREATE VIEW Statement

DROP Statement

DROP USER or GROUP Statement

GRANT Statement

REVOKE Statement



Community Additions

ADD
Show:
© 2014 Microsoft