Hands-on with PostgreSQL Authorization – Part 2 – Row-Level Security

Roles and Grants
Row-Level Security (this article)
Performance of Row-Level Security (coming soon!)

In the first article, we looked into how database roles and granted privileges can be used to control what database objects (e.g. tables, views, functions) can be accessed and modified (with SELECT, INSERT, UPDATE, and DELETE queries) by different users. That article ended with a bit of a cliffhanger: if you build a multi-user application using only roles and GRANTs for au…