CREATE SERVICE ACCOUNT reference

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

Syntax#

Flow chart showing the syntax of the CREATE SERVICE ACCOUNT keyword

Description#

CREATE SERVICE ACCOUNT adds a new service account with no permissions to QuestDB instance. The chosen name must be unique across all users (including the built-in admin), groups and service accounts.

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

Examples#

CREATE SERVICE ACCOUNT audit;

It can be verified with:

SHOW SERVICE ACCOUNT audit;

that yields:

auth_typeenabled
Passwordfalse
JWK Tokenfalse
REST Tokenfalse

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