CREATE USER or GROUP Statement (Microsoft Jet SQL)

Microsoft Jet SQL Reference

CREATE USER or GROUP Statement

Creates one or more new users or groups.

Syntax

Create a user:

CREATE USER user password pid [, user password pid, …]

Create a group:

CREATE GROUP group pid[, group pid, …]


The CREATE USER or GROUP 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.
password The password to be associated with the specified user name.
pid The personal id.
Remarks

A user and a group cannot have the same name.

A password is required for each user or group that is created.


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