Getting Started With Authorization
Last updated
Last updated
Authorization in QueryDeck governs what actions authenticated users can perform and which data they can access. By defining roles and assigning permissions, QueryDeck ensures secure and flexible access control for your Postgres data.
Access the Roles & Authorization Page Navigate to the "Roles & Authorization" section in your app settings. You will see a prompt to set up authentication before creating roles and permissions.
Create a Role Once authentication is configured, click the "+" button to create a new role. In the "Create Role" modal:
Enter Role Name: Specify a name for the role (e.g., "Editor" or "Viewer").
Enter Role Value (Optional): Optionally define a role value for dynamic use.
Select Role Type: Choose a role type, such as "Admin" or "Custom."
Manage Roles After creating roles, they will appear in the "Roles & Authorization" section. From here, you can:
Edit: Modify the role name, value, or type.
Delete: Remove roles no longer in use.
Assign Permissions: Define specific database operation permissions for each role.
For example, "Admin" roles have predefined permissions, while "Custom" roles can be tailored to your needs.
You can define the table permissions by adding the table from your database upon clicking on the + Green icon.
Admin Role: Full access to all database operations.
Editor Role: Select, Insert, and Update permissions on specific tables.
Viewer Role: Read-only access (Select) to specific data.
With QueryDeck, managing role-based access is streamlined, ensuring your APIs remain secure and adaptable to your application's needs.
