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

I think we worked out something offline that will do the job.

totally gross

a view that applies PL/SQL functions to each column and depending on context, either returns that column value, or a null, spaces, or other desired non-data

the PL/SQL functions check a control table that has rows by username, table, column; if there is no entry, they get asterisks,nulls, spaces, whatever as a return instead for that column value

there's no way of getting around returning SOMEthing for each column, allowed or not, that I can think of, even if it is a null

of course this app will have to handle the results in a sane manner

yuck

everything else I thought of was even more diabolical and gross

rsh

"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message news:3c86a581.3095454_at_news.freeler.nl...
> 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 Thu Mar 07 2002 - 03:44:41 CST