Re: Can I replicate SELECT column permission without using multple views

From: RSH <RSH_Oracle_at_worldnet.att.net>
Date: Wed, 06 Mar 2002 17:50:03 GMT
Message-ID: <fFsh8.18097$gK2.1353913@bgtnsc04-news.ops.worldnet.att.net>

I reread your message and I'm now not sure what you are asking...I THOUGHT I solved this but you mentioned views in your message and so I presumably missed the target, if you already know how views can deal with this.

So what am I not getting? Or, as I ask my programmers "What is it, exactly,you are trying to do?"

Sorry I fired before aiming!

RSH. "Lee Farrant" <leefarrant_at_hotmail.com> wrote in message news:97ad5817.0203060736.74047415_at_posting.google.com...
> Hi
>
> I have a customer that wants to give some users access to some columns
> and other users access to other columns on the same table.
>
> they cannot implement Column Permissions because this does not support
> the SELECT column permission.
>
> One restriction they have is that the end users must only reference
> one view or table. So there needs to be some logic under this table or
> view.
>
> Is there a clever way around his :-(
>
> Thanks Lee
>
> leefarrant_at_hotmail.com
Received on Wed Mar 06 2002 - 11:50:03 CST