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

The original question was IMNSHO:

How can I create ONE view that will show a bunch of columns of a table for some users and another bunch of columns of the table for some other users.

I myself don't know a solution to this one.

Jaap.

On Wed, 06 Mar 2002 17:50:03 GMT, "RSH" <RSH_Oracle_at_worldnet.att.net> wrote:

>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 - 17:39:01 CST