Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: block a field

Re: block a field

From: David Boyd <davidb158_at_hotmail.com>
Date: Thu, 18 May 2006 14:13:58 -0400
Message-ID: <BAY101-F224A7A6CF3499AD9FAFA28EFA60@phx.gbl>


Thanks Wolfgang.

The performance is the same as

create view t1_view
as select other_fields, decode(priv, 1, id, '') id from t1, (select count(*) priv from security where user_name=user);

David

>From: Wolfgang Breitling <breitliw_at_centrexcc.com>
>Reply-To: breitliw_at_centrexcc.com
>To: davidb158_at_hotmail.com
>CC: oracle-l_at_freelists.org
>Subject: Re: block a field
>Date: Thu, 18 May 2006 10:53:57 -0700
>
>create view t1_view
>as select other_fields, decode(priv, 1, id, '') id
>from t1, (select count(*) priv from (select 1 security where
>user_name=user));
>?



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
Received on Thu May 18 2006 - 13:13:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US