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.