PostgreSQL Schema Permissions Investigation

PostgreSQL Schema Permissions Investigation: a task in Terminal-Lego-15k (Harbor dataset). You are a database administrator setting up PostgreSQL permissions for a web application. You need to understand the relationship between GRANT USAGE ON SCHEMA and table-level permissions to properly…

The task

You are a database administrator setting up PostgreSQL permissions for a web application. You need to understand the relationship between `GRANT USAGE ON SCHEMA` and table-level permissions to properly configure read-only access for an application role.

Part of PrimeIntellect/Terminal-Lego-15k.