ADD USER Statement (Microsoft Access SQL)

  • Article
Access Developer Reference

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 workgroup information 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 TABLE Statement

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