Re: Encrypting columns for some users
From: Michael D O'Shea <michael.oshea_at_tessella.com>
Date: Fri, 11 Jul 2008 03:48:57 -0700 (PDT)
Message-ID: <537e0437-81b4-4545-adbe-00966a4cc805@8g2000hse.googlegroups.com>
Date: Fri, 11 Jul 2008 03:48:57 -0700 (PDT)
Message-ID: <537e0437-81b4-4545-adbe-00966a4cc805@8g2000hse.googlegroups.com>
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.
hth
Mike
TESSELLA Michael.OShea_at_tessella.com
__/__/__/ Tessella Support Services plc __/__/__/ 3 Vineyard Chambers, ABINGDON, OX14 3PX, England __/__/__/ Tel: (44)(0)1235-555511 Fax: (44)(0)1235-553301www.tessella.com Registered in England No. 1466429 Received on Fri Jul 11 2008 - 05:48:57 CDT