RE: block a field
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <davidb158@xxxxxxxxxxx>, <joseph@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Jan 2006 14:11:49 -0500
You could do something like this in your view definition:
select DECODE(USER, <restricted_user1>, NULL, <restricted_user2>, NULL,
column1),
DECODE(USER, <restricted_user1>, NULL, <restricted_user2>, NULL,
column2), ...
In this case restriced users will still be getting "blocked fields", but
the only value they'll see is NULL.
Igor
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Boyd
Sent: Friday, January 06, 2006 1:44 PM
To: joseph@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: block a field
Thanks all for your quick response.
I should specify in more detail in my first message. Actually we want
blocking a field in an existing view, not a table. We don't want
maintain two sets of views and security. We prefer to modify those
existing views.
David
>From: Joseph Amalraj <joseph@xxxxxxxxxxxxxx>
>To: davidb158@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
>Subject: Re: block a field
>Date: Fri, 6 Jan 2006 10:33:48 -0800 (PST)
>
>
>
>David Boyd <davidb158@xxxxxxxxxxx> wrote: Hi List,
>
>Is there an easy way to block a field in a table for some users, but
>open to other users?
>
>David
>
>_________________________________________________________________
>Don?t just search. Find. Check out the new MSN Search!
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>Create a view on the table and users can access the view through a
>synonym
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
