Access Level

RioDB can optionally enable API access with user management. This is the default mode for RioDB cloud instances.
In this mode, users can use individual accounts to submit statements to RioDB.

There are only 4 levels of access to 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.

Note, RioDB does not implement object ownership. An user with STREAM role can drop streams created by other users. Users with WINDOW role can drop windows created by other users. And users with QUERY role can drop queries created by other users. Users cannot privately own the objects they create.

See the Admin section to learn how to enable/disable API access with user management (for on-prem deployments).