CREATE USER

Create a new database user.

Table of contents

Synopsis

CREATE USER username
[ WITH ( user_parameter = value [, ...]) ]

Description

CREATE USER is a management statement to create a new database user in the CrateDB cluster. The newly created user does not have any special privileges. The created user can be used to authenticate against CrateDB, see Host-Based Authentication (HBA).

The statement allows to specify a password for this account. This is not necessary if password authentication is disabled.

For usage of the CREATE USER statement see User management.

Parameters

username:

The unique name of the database user.

The name follows the principles of a SQL identifier (see Key words and identifiers).

Clauses

WITH

The following user_parameter are supported to define a new user account:

password:

The password as cleartext entered as string literal.