Mastering PostgreSQL 12 - Third Edition

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. 

The following topics will be covered in this chapter:

• Managing network security
• Digging into 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.