Assigning roles

The difference between Viewer, Editor, and Admin roles.

On PopSQL, there are three types of user roles - Viewers, Editors, and Admins.

Viewers are free teammates

When a new teammate joins an organization, they will automatically join as a Viewer role and be free. As long as the Viewer does not click on "Run" or "Refresh", they will maintain their free Viewer role.  This is typically a good role for those who are emailed or slacked reports or perhaps browse through your organization's dashboards.

Editors are teammates who are looking to run SQL queries

For any teammate who wants to edit or create queries or tailor queries by re-running them with different query variables, they will need to be assigned the editor role.

By default, there is a setting on your account that will allow a Viewer to become an Editor, automatically, if they click "Run" or "Refresh". If you would like to turn this off, you can reach out to [email protected], and we can turn this setting off for your organization.

Admins are power-editors with access to every resource

Admins can change any of your organization's settings. They can also access and edit any resources in your team's account. For example, they can edit a query even if the query is set to view only.

Cookie settings