ADD USER Statement (Microsoft Jet SQL)

Microsoft Jet SQL Reference

previous page next page

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


previous page start next page