No video of the event yet, sorry!

Checkout the slides

PostgreSQL has undergone significant security enhancements from version 10 to version 17, particularly in the areas of roles and permissions. This talk will provide an in-depth overview of these changes, focusing on the impact of the new security measures on database management and user access control. Key topics will include the removal of default CREATE privileges for the public schema in version 15, the introduction of ADMIN OPTION for role privileges in version 16, and the tightened security for logical replication in version 17. Attendees will gain insights into how these changes enhance security by preventing unauthorized access and privilege escalation, and how they can implement these measures in their own PostgreSQL environments to improve data integrity and security. The session will also touch on future enhancements being discussed, such as publication privileges, which promise even finer-grained access control in upcoming versions.

This talk is ideal for database administrators, security professionals, and developers who are looking to stay updated on the latest security features in PostgreSQL and learn best practices for securing their databases.