CREATE USER or GROUP statement (Microsoft Access SQL)

Applies to: Access 2013, Office 2013

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.