| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: block a field
You could do something like this in your view definition:
select DECODE(USER, , NULL, , NULL,
column1),
DECODE(USER, , NULL, , 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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Boyd
Sent: Friday, January 06, 2006 1:44 PM
To: joseph_at_amalrajinc.com; oracle-l_at_freelists.org
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
>To: davidb158_at_hotmail.com, oracle-l_at_freelists.org
>Subject: Re: block a field
>Date: Fri, 6 Jan 2006 10:33:48 -0800 (PST)
>
>
>
>David Boyd 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/
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
>
>Create a view on the table and users can access the view through a
>synonym
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 06 2006 - 20:11:49 CST
 |
 |