- An engine can connect to multiple databases.
- A database can be accessed by multiple engines.
If a user lacks USAGE and OPERATE privileges for an engine, they will not be able to select or interact with the engine via the Firebolt UI.
Examples of granting engine permissions
USAGE permission
The following code example grants the roledeveloper_role permission to use the myEngine engine for executing queries:
OPERATE permission
The following code example gives the roledeveloper_role permission to start and stop the myEngine engine:
MODIFY permission
The following code example grants the roledeveloper_role permission to alter properties or drop the myEngine engine:
MONITOR [USAGE] permission
The following code example grants the roledeveloper_role permission to see the query history and currently running queries for the engine myEngine:
ALL permissions
The following code example grants the roledeveloper_role with all engine permissions on myEngine: