Re: Encryption

Hmmm - data encryption at the table level is problematic - consider the effect on indexes etc which would also have to encrypt data. Performance would likely be unacceptable. And what key is used the the encryption - one per user (untenable is you are sharing data), or an overall one of for the entire database (in which case backups provide an easy backdoor - somebody could just restore the backup into a clone database).

If you are looking at locking down your data you may want to investigate security policies in Oracle8i (allows you to roll you own 'poor man' Trusted Oracle type capabilities). Combining security policies with on the wire network encryption is pretty secure.

Alberty Pascal wrote:
>
> >Are you looking for data to be encrypted when it's stored in the table or
> as
> >the data passes around the network? If it's the former, Oracle doesn't
> >provide built-in functionality to do that, but it's easy enough to write
> >your own method using PL/SQL. If it's the latter, look at the Advanced
> >Networking Option.
>
> Yes, i'm searching to encrypt data stored in the table.
>
> Well, thanks both of you for your answers.
>
> ----------------------------------------------------------------------
> pal_at_bsb*nospam.be
> Please remove *nospam if you want to send me a mail

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com