Boriss Mejias - EDB - Data Access Control in PostgreSQL with Row-Level Security - Percona Live 2021

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. You can find more information about #PostgreSQL #Databases and Percona Database Events in these links 👇👇👇 Postgresql Support ⏩ per.co.na/postgresql-support Postgresql info ⏩ per.co.na/postgresql-info Postgresql events ⏩ per.co.na/pl2020 Percona Distribution for PostgreSQL ⏩ per.co.na/postgresql Monitor your PostgreSQL For Free ⏩ percona.tv/pmm-yt Connect With us on our Social Networks 👇👇👇 Follow Percona on Twitter: per.co.na/twitter Follow Percona on Facebook: per.co.na/facebook Follow Percona on Instagram: per.co.na/instagram Follow Percona on LinkedIn: per.co.na/linkedin

• #science_technology
• #postgresql
• #postgresql_row_level
• #postgresql_optimization
• #percona_live_2021
• #percona
• #percona_tutorial
• #postgresql_best_practices
• #row_level_security_postgresql
• #row_level_security_database
• #postgresql_edb
• #postgresql_security
• #postgresql_data_access
• #database_data_access
• #what_is_postgresql
• #postgresql_tutorial
• #postgresql_tutorial_for_beginners