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 ...