PGConf NYC 2021 - Data Security using Roles, Privileges and Row Level Security by Abbas Butt

Data Security using Roles, Privileges and Row Level Security by Abbas Butt In this talk we will discuss all the privileges that can be granted to roles in PostgreSQL. We will also discuss What exact permission is provided by each privilege to the roles. We will then go through the design and implementation of a sample message exchange application that uses PL/pgSQL, privileges and row level security (RLS) to implement authorization and security features. By going through the implementation we will show one of the many use cases of RLS.