Re: column masking in 10g

  • From: "David Boyd" <davidb158@xxxxxxxxxxx>
  • To: jheinrich@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 01 Mar 2007 09:40:43 -0500

Jason,
Thanks for your input. As you said we do have synonyms in place and don't want using views. 

Dave


From: Jason Heinrich <jheinrich@xxxxxxxx>
To: <davidb158@xxxxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
Subject: Re: column masking in 10g
Date: Thu, 01 Mar 2007 08:22:14 -0600

One solution that doesn't involve VPD is to just create a view that doesn't
include that column. Then grant access to the view to your restricted users 
and revoke their access to the base table.  Of course, unless you have
synonyms in place for this table, this would involve changing the code that
accesses the table.


_________________________________________________________________
Mortgage rates as low as 4.625% - Refinance $150,000 loan for $579 a month. Intro*Terms https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h27f6&disc=y&vers=743&s=4056&p=5117 

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007