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 as well as certification-related issues. 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 and handling 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 with managing network security.
