Re: Confidential data

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 29 Apr 2003 06:59:25 -0700
Message-ID: <2687bb95.0304290559.73329249@posting.google.com>

Thierry <thierry.lpjob_at_caramail.com> wrote in message news:<2003429-103047-85104_at_foorum.com>...
> Hi,
>
> I would like to know if it is possible to have privileges to administrate a
> database as a dba (export/import, backups, managing tablespaces, ...) without
> any access to the data in that database (because confidential datas). If yes,
> how to do that (or where could I find that note, procedure, explanation, ... if
> too long for an answer ?).
> Regards,
> Thierry

A DBA always has access to the data. If you do not trust your DBA's and System Administrators then you need new ones.

You can encrypt the data so that it is meaningless when viewed outside of the application. See the Oracle supplied Packages manual entry for DBMS_OBFUSCATION_TOOLKIT. There are numerous posts on this subject and using the package at metalink.oracle.com.

HTH -- Mark D Powell -- Received on Tue Apr 29 2003 - 08:59:25 CDT