Re: Restricting administrator's DB access

From: Mike Ivanov <mikei(at)activestate(dot)com>
To: Ankur Sam <sambhar_a(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Restricting administrator's DB access
Date: 2009-07-01 21:31:29
Message-ID: 4A4BD5B1.6070009@activestate.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Ankur,

> Is it doable by granting the restricted permissions?
>
No.

> Else another option would be to store the encrypted data but it would have a
> performance hit.
>
Yes.

That is your choice: either security or performance.

> Any pointers/suggestions would be much appreciated.
>
http://www.postgresql.org/docs/8.3/static/pgcrypto.html

Cheers,
Mike

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Gould 2009-07-02 12:58:13 Questions on setup and usage
Previous Message Gilberto Castillo Martínez 2009-07-01 21:16:24 Re: Gilberto