Re: know would you encrypt/encode/hide the value in a column?

From: Steve Phelan <stevep_at_pmcgettigan.demon.co.uk>
Date: 1997/04/21
Message-ID: <335B1A75.47318921@pmcgettigan.demon.co.uk>#1/1

wrote:

> Is there anyway that you know of to encrypt/encode/hide the value
> in a column, and still be able to use the actual value
> in a query (e.g., say you wanted to identify employees by SSN and
> group by this attribute, but didn't want the SSN known)?
>
> I have look briefly in my ORACLE reference,
> but haven't been able to find anything.
>
> Thanks!
> Santiago Cabezas
> CP&L
> santiago.cabezas_at_cplc.com

Well, you could encrypt/decrypt the data in the column in your application, but this may be overkill.

Have you considered creating a view on the table which only shows the columns you want users to be able to see? You could then let the users access the view, but not the table, by using Oracle's normal privileges based security schemes (i.e., roles, etc.)

Steve Phelan. Received on Mon Apr 21 1997 - 00:00:00 CDT