CREATE USER reference

CREATE USER - create a new user in the database.

For full documentation of the Access Control List and Role-based Access Control, see the RBAC operations page.

note

Role-based Access Control (RBAC) operations are only available in QuestDB Enterprise & QuestDB Cloud.

---

Syntax

Description

CREATE USER adds a new user with no permissions, optionally a password can also be set for the user.

The chosen name must be unique across all users (including the built-in admin), groups and service accounts. If the name has already been reserved, the command fails and an error is raised, unless the IF NOT EXISTS clause is included in the statement.

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 IF NOT EXISTS 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