Percona Live Online

Row-Level Security has been around in PostgreSQL since version 9.5, but very few projects are using it. This is probably because applications have been historically controlling access to data at the level of the application. Delegating data access control to the database is not common practice, but now it is possible with Row-Level Security (RLS). In this talk we will cover from the basics of RLS to some design patterns to move data access control to PostgreSQL, simplifying parts of the implementation of the application.