Mark D Powell schreef:
> Frank van Bortel wrote:
>> Tubby schreef:
>>> I have a few columns in a table for which the data needs to be
>>> encrypted. How do I go about creating the required Encryption and
>>> Decryption using the DBMS_Obfuscation_Toolkit?
>>>
>>> I was unsuccessful when I wrote Triggers on the Table requiring
>>> Encryption as it had a Mutating effect. One was a Statement and the
>>> other for Each Row.
>>>
>>> Any help would be greatly appreciated.
>>>
>> In 10G Release 2, use encrypted columns (transparant data
>> encryption).
>> I have an entry on that:
>> http://vanbortel.blogspot.com/2005_07_01_vanbortel_archive.html
>>
>> --
>> Regards,
>> Frank van Bortel
>>
>> Top-posting is one way to shut me up...
>
> But the problem with transparent data encryption is that Oracle
> automatically decrypts the data for the user if they have select on the
> table. In most cases if you need to encrypt the data you are
> encrypting it from the majority of the users who select on the table.
> That is not to say the feature does not have merit or Frank was wrong
> for mentioning the option. Sensitive data can be protected via the
> feature from users skimming data from scans of export files, hot
> backups files, or direct reading of the database files. The feature
> just does not eliminate the need to separately encrypt sensitive data.
>
> IMHO -- Mark D Powell --
>
Very correct - but the OP did not give any hint as to
the purpose of this exercise...
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sun Jun 04 2006 - 09:25:33 CDT
