Hi all,

what possibilities you see in questioning of data encryption.

I have 10G database and customer wants to encrypt a certain columns in
certain table.

rgds
SS

Simo Silmu wrote:
> Hi all,
>
> what possibilities you see in questioning of data encryption.
>
> I have 10G database and customer wants to encrypt a certain columns in
> certain table.
>
> rgds
> SS

You can use dbms_crypto to encrypt. You can probably set some trigger
so when that column is inserted or updated, encrypted data is saved.
Data in that column will be shown as encrypted when doing any selects
(unlike TDE of 10gR2).

If you ever have to process data as decrypted inside your code you can
use dbdm_crypto to decrypt.

Simo Silmu wrote:
> Hi all,
>
> what possibilities you see in questioning of data encryption.
>
> I have 10G database and customer wants to encrypt a certain columns in
> certain table.
>
> rgds
> SS

Demos of the DBMS_CRYPTO built-in package can be found in Morgan's
Library at www.psoug.org.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

"DA Morgan" <damorgan@psoug.org> wrote in message
news:1156999740.968123@bubbleator.drizzle.com...
> Simo Silmu wrote:
>> Hi all,
>>
>> what possibilities you see in questioning of data encryption.
>>
>> I have 10G database and customer wants to encrypt a certain columns in
>> certain table.
>>
>> rgds
>> SS
>
> Demos of the DBMS_CRYPTO built-in package can be found in Morgan's
> Library at www.psoug.org.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Thanks a lot!

Excellent!