If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > Restricting administrator's DB access

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 06-26-09, 09:22
ankur sam ankur sam is offline
Registered User
 
Join Date: Jun 2009
Posts: 1
Restricting administrator's DB access

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
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On