In this chapter, we will cover the following recipes:

  • The PostgreSQL superuser
  • Revoking user access to a table
  • Granting user access to a table
  • Granting user access to specific columns
  • Granting user access to specific rows
  • Creating a new user
  • Temporarily preventing a user from connecting
  • Removing a user without dropping their data
  • Checking whether all users have a secure password
  • Giving limited superuser powers to specific users
  • Auditing DDL changes
  • Auditing data changes
  • Always knowing which user is logged in
  • Integrating with LDAP
  • Connecting using SSL
  • Using SSL certificates to authenticate
  • Mapping external usernames to database roles
  • Encrypting sensitive data

Get PostgreSQL Administration Cookbook, 9.5/9.6 Edition now with O’Reilly online learning.

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