Re: Encrypting columns for some users

From: <vitalisman_at_gmail.com>
Date: Fri, 11 Jul 2008 02:46:04 -0700 (PDT)
Message-ID: <2efd8281-c490-4902-af47-a2c9587a3fa4@56g2000hsm.googlegroups.com>


On Jul 11, 8:35 am, Carlos <miotromailcar..._at_netscape.net> wrote:
> On 10 jul, 17:45, 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
>
> What happened to the good old views? ;-)
>
> Cheers.
>
> Carlos.

Thanks Carlos. That's a good solution (but it needs some additional schema objects though.) Received on Fri Jul 11 2008 - 04:46:04 CDT

Original text of this message