CREATE SERVICE ACCOUNT reference

To create a new service account in the database, the CREATE SERVICE ACCOUNT keywords are used.

Syntax

Description

CREATE SERVICE ACCOUNT adds a new service account with no permissions to QuestDB instance. Chosen name has to be unique across all users, groups and service accounts.

Examples

CREATE SERVICE ACCOUNT audit;

It can be verified with:

SHOW SERVICE ACCOUNT audit;

that yields:

auth_type	enabled
Password	false
JWK Token	false
REST Token	false