Row Level Security with Postgres (via Hasura AuthZ)

This article discusses the basics of Postgres Row-level Security (RLS) and how Hasura handles permission rules. RLS allows developers to control access to rows in a database table based on rules evaluated during query execution. To enable RLS, use the ALTER TABLE ... ENABLE ROW LEVEL SECURITY command. Policies are created using USING or WITH CHECK expressions, which return boolean values representing if permission is granted. Hasura's authorization system (AuthZ) provides a more efficient solution for handling permissions across multiple data sources and supports role-based access control rules for every field in the GraphQL schema.