Re: block a field

From: Connor McDonald <mcdonald.connor_at_gmail.com>
Date: Sun, 16 Jul 2006 21:52:44 +0800
Message-ID: <5e3048620607160652r30e59744y4cc81532d9b316eb@mail.gmail.com>

On 5/19/06, David Boyd <davidb158_at_hotmail.com> wrote:
> 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_at_yahoo.com
web:   http://www.oracledba.co.uk

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

Received on Sun Jul 16 2006 - 08:52:44 CDT