Prev: Multiple Queries
Next: Help: Ungrading OS
From: vitalisman on 10 Jul 2008 11:45
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
From: Carlos on 11 Jul 2008 02:35
On 10 jul, 17:45, vitalis...(a)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.
From: vitalisman on 11 Jul 2008 05:46
On Jul 11, 8:35 am, Carlos <miotromailcar...(a)netscape.net> wrote:
> On 10 jul, 17:45, vitalis...(a)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.)
From: Michael D O'Shea on 11 Jul 2008 06:48
On Jul 10, 4:45 pm, vitalis...(a)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.

hth
Mike


TESSELLA Michael.OShea(a)tessella.com
__/__/__/ Tessella Support Services plc
__/__/__/ 3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/ Tel: (44)(0)1235-555511 Fax: (44)(0)1235-553301
www.tessella.com Registered in England No. 1466429



From: vitalisman on 11 Jul 2008 07:01
On Jul 11, 12:48 pm, "Michael D O'Shea" <michael.os...(a)tessella.com>
wrote:
> On Jul 10, 4:45 pm, vitalis...(a)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).
 | 
Pages: 1
Prev: Multiple Queries
Next: Help: Ungrading OS