Skip to main content
Skip table of contents

Role-based Web UI Restrictions

By default, a user has access to all elements in the Web UI. In order to introduce UI restrictions for users, the administrator must assign the respective UI role to the user along with any other required role populated with the server resource permissions. If none of the roles is assigned, the UI remains unrestricted. This is important to maintain backward compatibility.

The available UI roles are as described in the table:

RoleRole nameDescription
Business Userbusiness-user-role

This role has access to the Data Shop, can download Excel files, can connect Tableau.

This role is restricted from seeing the Dashboard, Data Warehouses, Sources, Jobs, Code Editor, and Materialisation tabs, as well as from seeing the “Show data in the Code Editor” button

SQL Usersql-user-role

This role has all permissions of a Business User and is allowed to see and use the Code Editor, but only SELECT statements. 

This role is restricted from seeing and using other SQL statements, Materializations, Jobs, etc.

SQL Developersql-developer-roleThis role has all permissions of an SQL User and has full access to the Dashboard, Code Editor, Materializations, and Jobs
Data Source Administratordata-source-admin-roleThis role has all permissions of an SQL Developer, can view/add/edit Data Sources, and has access to the Data Warehouses and Sources tabs

User roles are available since v4.7

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.