This discussion is archived
3 Replies Latest reply: Nov 5, 2012 10:36 AM by Justin Cave RSS

Restricting DBA Access to all data of the tables ( Encryption / Others )

918140 Newbie
Currently Being Moderated
Hi,

We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .

Could you please share on the solution possibilities ?.

1) Web Based Interface ?.

2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)

3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)

4) Standard Tools / Utilities / Others ??.

Technologies are Oracle ,SQL

Thanks for your quick input here

Regards

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points