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