User Management

CREATE USER

Users can be created with the CREATE USER statement as follows:

CREATE USER user1 WITH PASSWORD 'user1Password!' READWRITE;

Possible permissions are: READ, READWRITE and ADMIN.

An admin user is able to fully manage the current database.

ALTER USER

User password and permissions can be modified with the ALTER USER statement as follows:

ALTER USER user1 WITH PASSWORD 'newUser1Password!' ADMIN;

DROP USER

An existing user can be deleted. Deletion is logically done and the user can be reactivated by executing an ALTER USER statement.

DROP USER user1;