Re: Encrypting columns for some users

From: Michael D O'Shea <>
Date: Fri, 11 Jul 2008 03:48:57 -0700 (PDT)
Message-ID: <>

On Jul 10, 4:45 pm, 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?
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.



__/__/__/  Tessella Support Services plc
__/__/__/  3 Vineyard Chambers, ABINGDON, OX14 3PX, England
__/__/__/  Tel: (44)(0)1235-555511  Fax: (44)(0)1235-553301 Registered in England No. 1466429 Received on Fri Jul 11 2008 - 05:48:57 CDT

Original text of this message