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. Let’s now start off with managing network security.
