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.