Re: Can Oracle encrypt fields in a table?

From: <mark.powell_at_eds.com>
Date: Fri, 26 Feb 1999 15:21:17 GMT
Message-ID: <7b6e53$9oo$1@nnrp1.dejanews.com>

In article <dolans.919957424_at_stripe.Colorado.EDU>, dolans_at_stripe.Colorado.EDU (Sean Dolan) wrote:
> Can Oracle 7.3.4 or a PACKAGE somewhere encrypt a field in a database. I know the Oracle system encrypts users passwords when loggin in, but if we wanted to store sensitive info (like credit cards) in a table, can Oracle encrypt it? Or would I need to pass the string through some external component first to encrypt, then place that value in the database? If so, any recommendations?
>
> Thanks,
> Sean Dolan
> sean_at_3si.com
>

Rather than writing your own fuctions to encrypt and decrypt data in a column, have you looked into Oracle column level priviledges? This coupled with views can often give you the security you need otherwise, you have to write your own routines.

Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice --

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 26 1999 - 09:21:17 CST