On 5/19/06, David Boyd <davidb158@(protected):
> 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);
>

how about

create view V as
select ..., decode(sys_context('USERPRIVS','PRIVS'),1,id))
from t1

where you set the context at logon time etc.

hth
connor

--
Connor McDonald
===========================
email: connor_mcdonald@(protected)
web:  http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"
--
http://www.freelists.org/webpage/oracle-l