Print

Change User

The CHANGE USER commands is used to change the role or the password of an existing user in RioDB.
Again, there are 4 access levels in RioDB:

  • QUERY – Gives access to create/remove queries (SELECT … FROM …)
  • WINDOW – Gives access to QUERIES plus create/remove windows (CREATE WINDOW …)
  • STREAM – Gives access to WINDOWS plus create/remove streams (CREATE STREAM …)
  • ADMIN – Gives access to everything, including managing users and SYSTEM commands.

On RioDB Cloud instances, the ADMIN privilege is not given to customers.

Access Rule

Requires ADMIN role.

Syntax

CHANGE USER <username> SET ACCESS <accesslevel> ;
CHANGE USER <username> SET PASSWORD '<newpassword>';

Example

CHANGE USER bob SET ACCESS query;
CHANGE USER bob SET ACCESS window;
CHANGE USER bob SET ACCESS stream;
CHANGE USER bob SET ACCESS admin;
CHANGE USER bob SET PASSWORD 'T3llM3When!';
CHANGE USER bob SET PASSWORD 'T3llM3When!';

The command to reset own password is RESETPWD.

Table of Contents
Scroll to Top