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.