Re: column masking in 10g

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 01 Mar 2007 09:40:43 -0500
Message-ID: <BAY101-F2468D112A3943B5E58E723EF800@phx.gbl>

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_at_pcci.edu>
>To: <davidb158_at_hotmail.com>,<oracle-l_at_freelists.org>
>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

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

Received on Thu Mar 01 2007 - 08:40:43 CST