Re: limiting access to (through) views

Stephan,

Thanks again.
The CURRENT_USER function returns just the username, my table actually has
username(at)server(dot)

Glenn

----- Original Message -----
From: "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Glenn MacGregor" <gtm(at)oracom(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Sent: Wednesday, January 16, 2002 10:44 AM
Subject: Re: [SQL] limiting access to (through) views

>
> On Wed, 16 Jan 2002, Glenn MacGregor wrote:
>
> > Thanks,
> >
> > Now is it possible to do the following:
> >
> > select table1.* from
> > table1, table2 where
> > table1.col3=table2.key and
> > table2.username like 'CURRENT_USER%'
> >
> > This is returning nothing when I know it should be returning something,
so I
> > think that since the CURRENT_USER is in the ' it is not executing the
> > function. Is there a way to make that execute using the like with the
regex
> > matching (%)?
>
> Do you really want a like search or are you trying to get around it not
> matching something?
> table2.username like CURRENT_USER || '%' would probably work.
>
>