pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Glenn MacGregor <gtm@oracom.com>
To: Stephan Szabo <sszabo@megazone23.bigpanda.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: limiting access to (through) views
Date: Wed, 16 Jan 2002 10:58:56 -0500
Message-ID: <01c201c19ea6$b40ec0b0$4d00a8c0@catamount> (raw)
References: <20020116074331.G44027-100000@megazone23.bigpanda.com>

Stephan,

Thanks again.
The CURRENT_USER function returns just the username, my table actually has
username@server.

    Glenn

----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Glenn MacGregor" <gtm@oracom.com>
Cc: <pgsql-sql@postgresql.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.
>
>




view thread (6+ messages)

Message-ID: <01c201c19ea6$b40ec0b0$4d00a8c0@catamount>
Permalink:  ../01c201c19ea6$b40ec0b0$4d00a8c0@catamount/
Also on:    postgresql.org/message-id/01c201c19ea6$b40ec0b0$4d00a8c0@catamount

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: gtm@oracom.com, sszabo@megazone23.bigpanda.com
  Subject: Re: limiting access to (through) views
  In-Reply-To: <01c201c19ea6$b40ec0b0$4d00a8c0@catamount>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox