O'Reilly logo

PostgreSQL 9 Administration Cookbook - Second Edition by Simon Riggs, Gianni Ciolli, Hannu Krosing, Gabriele Bartolini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 6. Security

In this chapter, we will cover the following recipes:

  • The PostgreSQL superuser
  • Revoking user access to a table
  • Granting user access to a table
  • 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 the client
  • Mapping external usernames to database roles
  • Encrypting sensitive data

Introduction

Databases are mostly used to keep data with several restrictions on how it can be used. Some records or tables can only be seen by certain ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required