Authorization

Introduction

Roles & Authorization in QueryDeck defines what data and operations a verified user can access.

QueryDeck supports role-based authorization, enabling you to control access to your Postgres data through well-defined permissions. Permissions are assigned per user role and database operation, ensuring secure and precise access control for each table.

For every authenticated request to QueryDeck, dynamic session variables from your authentication service—such as a role identifier—are used to enforce these rules. You can configure permissions for actions like Select, Insert, Update, and Delete, tailoring them to each role's specific needs.

With QueryDeck's flexible authorization system, managing secure and role-specific access to your data is both straightforward and efficient.

Getting started with Roles and Authorization