User Management and Securing Databases

Abstract

In the last chapter, we talked about configuring a PostgreSQL database for a better performance, which includes tuning of several database-related parameters based on their behavior and also about operating system-related parameters that help to improve performance. In this chapter, we are going to talk about user management in PostgreSQL and securing databases by managing user privileges. We will also cover different types of privileges at object level and how we can best plan to utilize those granular level privileges to secure the databases, and different types of encryption techniques that you can use to secure your data.