Data Security Using Roles, Privileges and Row Level Security - PL/pgSQL Implementation

Explore comprehensive data security strategies in PostgreSQL through a 42-minute conference talk from PGConf NYC 2021. Delve into the intricacies of roles, privileges, and Row Level Security (RLS) as presented by Abbas Butt. Gain a thorough understanding of the various privileges that can be granted to roles in PostgreSQL and learn the specific permissions each privilege provides. Follow along as the speaker designs and implements a sample message exchange application, demonstrating practical use of PL/pgSQL, privileges, and RLS to enforce robust authorization and security features. This insightful presentation showcases the power and versatility of Row Level Security, illustrating one of its many potential applications in real-world scenarios.