Skip to content
Pivot is in early development and is not production ready. See Project status.

CREATE USER

CREATE USER adds a login user to the server. The user is written to the metastore file, so the statement is refused when the configuration names no metastore, and it refuses a name the configuration already defines.

Replace the example password before running:

CREATE USER analyst PASSWORD 'replace-with-your-password';
CREATE USER name [PASSWORD 'password'];

name identifies the login. Supplying PASSWORD configures password authentication.

Omitting PASSWORD creates a trusted user: the server accepts the login name without checking a password.

CREATE USER local_analyst;