Talk by Ryan Booz

https://www.socallinuxexpo.org/scale/...

Security is an essential, yet often misunderstood, part of effectively managing a PostgreSQL cluster. As the popularity and adoption of PostgreSQL continues to grow, the interaction of roles, privileges, and object ownership is a recurring theme of confusion in forums and mailing lists. In this session we’ll demystify how ownership and permissions work in PostgreSQL so that you can more effectively manage your database landscape.