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));
?

Quoting David Boyd <davidb158@(protected)>:

> create view t1_view
> as select other_fields, decode(priv, 1, id, '') id
> from t1, (select count(*) priv from security where user_name=user);
>
> t1 is a huge table. The query does not use the index when I do (select *
> from t1_view where id='123'). However if I create the view in following way
>
>
> Does any one know if it's possible to return a value even a null value from
> (select 1 from security where user_name=user) instead of no rows returned
> when the user is not in the security table? or do you have a better way to
> block a field?
>
>--
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

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