Re: Looking for a method to encrypt data within an Oracle database, hosted on a public net, and accessed by thousands

jacob.marley_at_plaintalk.bellevue.wa.us wrote in article <5g88t2$mfl_at_Holly.aa.net>...
>
> Anyway, I am looking for a method to encrypt columns
> within an Oracle database

Just encrypt the data before storing it - remember though that you cannot encrypt any field (column) used as an Oracle primary key. For obvious reasons you also ought not to encrypt any field you expect to use in SQL statements such as SELECT or JOIN unless you are prepared - and able - to encrypt what goes into the SQL command string. This would complicate static SQL immensely and also mean that you had to distribute an encryption method to any user running API programs (SQL*Net and so forth).

In any case, do you really need to do this? Oracle has good admin/security mechanisms built in that will let you restrict access to tables/columns/whatever in the database.

Rick Received on Fri Mar 14 1997 - 00:00:00 CST