ADD USER Statement (Microsoft Jet SQL)

ADD USER Statement

Adds one or more existing users to an existing group.

Syntax

ADD USER user[, user, …] TO group

---

The ADD USER statement has these parts:

Part	Description
user	The name of a user to be added to the workgroup information file.
group	The name of a group to be added to the workgroupinformation file.

Remarks

Once a user had been added to a group, the user has all the permissions that have been granted to the group.

---

See Also

ALTER USER or DATABASE 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