CREATE USER reference

CREATE USER - create a new user in the database.

Syntax

Description

CREATE USER adds a new user to QuestDB instance, with optional password. Chosen name has to be unique across all users (including superadmin), groups and service accounts.

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_type	enabled
Password	false
JWK Token	false
REST Token	false

Create user with password

CREATE USER jane WITH PASSWORD secret;

In this case SHOW USER command returns:

auth_type	enabled
Password	true
JWK Token	false
REST Token	false