3 Replies Latest reply on Nov 5, 2012 6:36 PM by JustinCave

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


      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