8

Managing PostgreSQL Security

In Chapter 7, Writing Stored Procedures, we learned about stored procedures and writing server-side code. After being introduced to many other important topics, it is now time to shift to PostgreSQL security. Here, we will learn how to secure a server and configure permissions to avoid security breaches. Security is an important aspect and is getting increasingly important as applications are exposed to more and more internal, as well as external, threats.

The following topics will be covered in this chapter:

  • Managing network security
  • Digging into row-level security
  • Inspecting permissions
  • Reassigning objects and dropping users

By the end of the chapter, we will be able to professionally configure PostgreSQL security. ...

Get Mastering PostgreSQL 15 - Fifth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.