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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial