Managing PostgreSQL Security

In Chapter 7, Writing Stored Procedures, we learned about stored procedures and writing server-side code. After being introduced to many 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 preaches.

The following topics will be covered in this chapter:

  • Managing network security
  • Digging into Row-Level Security (RLS)
  • Inspecting permissions
  • Reassigning objects and dropping users

By the end of the chapter, we will be able to professionally configure PostgreSQL security. Let's now start off with managing network security.

Managing network security

Before moving on to real-world, practical examples, let's briefly focus ...

Get Mastering PostgreSQL 13 - Fourth 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.