CREATE USER reference

CREATE USER - create a new user in the database.

Syntax#

Flow chart showing the syntax of the CREATE USER keyword

Description#

CREATE USER adds a new user to QuestDB instance, with optional password. The chosen name has to be unique across all users (including the built-in admin), groups and service accounts.

Note that new users can only access the database if the necessary endpoint permissions have been granted.

Examples#

Create new user without password#

CREATE USER john;
-- or
CREATE USER john WITH NO PASSWORD;

It can be verified with:

SHOW USER john;

that yields:

auth_typeenabled
Passwordfalse
JWK Tokenfalse
REST Tokenfalse

Create user with password#

CREATE USER jane WITH PASSWORD secret;

In this case SHOW USER command returns:

auth_typeenabled
Passwordtrue
JWK Tokenfalse
REST Tokenfalse

โญ Something missing? Page not helpful? Please suggest an edit on GitHub.