Chapter 3. Users and Permissions

This chapter is all about users and permissions. You will be guided through the essential concepts and ideas of the PostgreSQL security system.

In this chapter, you will learn the following topics:

  • Network security
  • Users and roles
  • Common pitfalls
  • Securing procedures
  • Managing SSL
  • Using SELinux

Understanding PostgreSQL security

In this section, you will learn about the basic PostgreSQL security model. In general, we can see the PostgreSQL security models as seven basic layers:

  • Level 1: Turning the TCP on or off (listen_addresses in postgresql.conf, and so on)
  • Level 2: Network authentication (pg_hba.conf)
  • Level 3: Instance-level permissions
  • Level 4: Database-level permissions
  • Level 5: Schema-level permissions
  • Level 6: Table-level ...

Get PostgreSQL Administration Essentials now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.