Re: grant the right to select only certain rows?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fran Fabrizio <ffabrizio(at)mmrd(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: grant the right to select only certain rows?
Date: 2002-01-25 17:40:32
Message-ID: 26691.1011980432@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fran Fabrizio <ffabrizio(at)mmrd(dot)com> writes:
> And I have two database users, mary_smith and tom_white. If Mary Smith
> is the 1st grade teacher, is there any way to grant her access to only
> select rows where grade_level=1?

Make a VIEW that shows only those rows, and grant access to the view.
See the archives for past discussions.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Florian Wunderlich 2002-01-25 17:44:59 Re: persistent portals/cursors (between transactions)
Previous Message Gregory Wood 2002-01-25 17:33:51 Re: grant the right to select only certain rows?