Name: For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL ~ Ryan Booz
Start: 2025-08-13T12:00:00-04:00
End: 2025-08-13T13:00:00-04:00

**WHEN:**
**Wednesday, August 13, 2025, 1600 GMT**

**DESCRIPTION of TALK**
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, I’ll start by defining the Principle of Least Privileges and how this philosophy influences roles and privileges in PostgreSQL. Next, I’ll demonstrate the importance of object ownership in PostgreSQL, how group and user roles can work in unison to effectively manage permissions, multiple ways to manage default privileges, and which privileges should always be modified in any new PostgreSQL database. Finally, I’ll discuss how recent releases are laying a foundation for more flexible and robust security management in the years ahead.

By the end of this session, you will understand how roles work in PostgreSQL, how they impact your daily work, and how to effectively communicate security best practices with others on your team. You’ll leave with a solid information to start creating roles that effectively manage access to your cluster and data.

Taiob Ali

Julie Bloomquist

Surbhi Pokharna

Paresh Motiwala

Database Professionals Virtual Meetup Group

Azure Data Tech Groups

Technology

Database Administrators

SQL Azure

Database Professionals

Microsoft Azure

Database Development

Data Management

Big Data

NoSQL

Data Science

**Solutions Engineer at pganalyze**

Ryan is a Solutions Engineer at pganalyze focusing on PostgreSQL. Ryan has worked as a PostgreSQL advocate, developer, DBA and product manager for more than 25 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.
Ryan is a long-time DBA and developer, starting with MySQL and Postgres in the late 90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.

Database Professionals Virtual Meetup Group

For Your Eyes Only: Roles, Privileges, and Security in PostgreSQL ~ Ryan Booz

Database Professionals Virtual Meetup Group

Details

Members are also interested in