O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

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:

  • 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
  • Integrating with LDAP
  • Connecting using SSL
  • Encrypting sensitive data

Introduction

Databases are mostly used for keeping data, which has several restrictions on how it is used. Some records or tables can only be seen by certain users, and even for those tables which are visible to everyone, there can be restrictions on who can use the data, insert new data or change the existing data. ...

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