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@(protected)>
>Reply-To: breitliw@(protected)
>To: davidb158@(protected)
>CC: oracle-l@(protected)
>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