Implementing a Google Drive Style Hierarchical Authorization System in Hasura

This text discusses implementing a hierarchical authorization system similar to Google Drive's in Hasura. The author provides an overview of the scenario and schema for the database, which includes seven tables and several views used to calculate permissions. They then explain how to accomplish this by using SQL to dynamically generate the "flattened" view of relationships and folder <-> user <-> access level records. Finally, they demonstrate how to create permission rules in Hasura for allowing users to view or update folders based on their IDs and access types.