Re: Encrypting columns for some users

On Jul 11, 12:48 pm, "Michael D O'Shea" <michael.os..._at_tessella.com> wrote:
> On Jul 10, 4:45 pm, vitalis..._at_gmail.com wrote:
>
> > Hi,
>
> > 10g
> > Here is an unusual need: some users with read access to a table must
> > see the data in some specific columns as gibberish, while other users
> > still must be able to see them as clear text. It has to work with
> > sqlplus as well as other query tools.
>
> > Any idea?
> > TIA
>
> Hi, Oracle VPD sounds like what you are after. Perform a search on
> 'vpd' and 'column' and 'masking' for relevant hits and how to move
> forward.

Thanks Mike. It looks good for that purpose. I'll have to check whether NULL will be enough for our customer (as opposed to some gibberish text). Received on Fri Jul 11 2008 - 06:01:49 CDT