Restricting administrator's DB access

From: Ankur Sam <sambhar_a(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Restricting administrator's DB access
Date: 2009-06-26 11:38:46
Message-ID: 24218718.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hello,

I need to store the sensitive data in the database and would want to allow
the data retrieval/modification only through the application. So even the
administrator of the DB should NOT be allowed to update the data directly.
Also this restriction will only be applicable to few tables of the database.

Is it doable by granting the restricted permissions?

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

I am planning to use PostgreSQL and Oracle.

Any pointers/suggestions would be much appreciated.

Thanks
Ankur
--
View this message in context: http://www.nabble.com/Restricting-administrator%27s-DB-access-tp24218718p24218718.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Emanuel Calvo Franco 2009-06-26 15:09:35 Re: Optimal Flexible Architecture or Optimal Configuration Layout for Postgres
Previous Message Iñigo Martinez Lasala 2009-06-26 07:52:35 Re: PHP cann't access to postgres databse