4.8

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.