Re: limiting access to (through) views

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Glenn MacGregor <gtm(at)oracom(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: limiting access to (through) views
Date: 2002-01-16 15:23:14
Message-ID: 20020116152314.GA26996@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, Jan 16, 2002 at 09:47:21AM -0500,
Glenn MacGregor <gtm(at)oracom(dot)com> wrote:
> Hi All,
>
> I need to limit access to certain rows of a table. It was suggested to do this via a view, but it seems to me that I need the current username that is logged in to do this. Also I need to get info from another table inorder to make this work. Can I have multiple selects in a single view using the output of one in another?

You would want to use session_user or current_user. For now these are both
the same, but eventually they may not be.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Wei Weng 2002-01-16 15:36:54 Re: Count Total on a limited query?
Previous Message Stephan Szabo 2002-01-16 15:17:04 Re: limiting access to (through) views