GavinRay97/index.md

## index.md

      
    Raw
  

              index.md
            
          
    Introduction

This document outlines how to model a common organization-based permission system in Hasura. Let's assume that you have some table structure like the following:


Table Name
Columns
Foreign Keys


User
id, name, email


Organization User
id, user_id, organization_id
user_id -> user.id, organization_id -> organization.id


Organization
id, name


Example Data

Here we have example users, two (John and Jane) belonging to Organization ID 1, and Frank belonging to Organization ID 2:


User
Organization User
Organization


Relationships

We create the following relationships on our data:


User
Organization User
Organization


Permissions

And provision the permissions like such:


User
Organization User
Organization


Query Results

Now when we query with our X-Hasura-User-Id set as User 1 and 3 respectively, we can see only those users in our own organizations:


User ID 1 (Org 1)
User ID 3 (Org 2)
Table Name	Columns	Foreign Keys
User	id, name, email
Organization User	id, user_id, organization_id	user_id -> user.id, organization_id -> organization.id
Organization	id, name