CREATE USER or GROUP Statement (Microsoft Access SQL)

  • Article
Access Developer Reference

Creates one or more new users or groups.

Syntax

Create a user:

CREATE USER userpassword pid [, userpassword pid, …]

Create a group:

CREATE GROUP grouppid[, grouppid, …]

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

ALTER TABLE Statement

ALTER USER or DATABASE Statement

CONSTRAINT Clause

CREATE INDEX Statement

CREATE PROCEDURE Statement

CREATE TABLE Statement

CREATE VIEW Statement

DROP Statement

DROP USER or GROUP Statement

GRANT Statement

REVOKE Statement