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

Channel:

Confreaks

Subscribers:

42,400

Published on October 12, 2022 3:00:00 PM ● Video Link: https://www.youtube.com/watch?v=0-YBf2QzATE

Duration: 41:37

39 views

0

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.