Re: Encrypting columns for some users
Date: Fri, 11 Jul 2008 03:48:57 -0700 (PDT)
On Jul 10, 4:45 pm, vitalis..._at_gmail.com wrote:
> 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-553301www.tessella.com Registered in England No. 1466429 Received on Fri Jul 11 2008 - 05:48:57 CDT