Postgres Pro
Downloads
Home   >   mailing lists

Re: grant the right to select only certain rows? - Mailing list pgsql-general

From Tom Lane
Subject Re: grant the right to select only certain rows?
Date
Msg-id 26691.1011980432@sss.pgh.pa.us
Whole thread Raw
In response to grant the right to select only certain rows?  (Fran Fabrizio <ffabrizio@mmrd.com>)
List pgsql-general
Tree view 
Fran Fabrizio <ffabrizio@mmrd.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

pgsql-general by date:

Previous
From: "Campano, Troy"
Date:
Subject: Re: grant the right to select only certain rows?
Next
From: "Hiroshi Inoue"
Date:
Subject: Re: persistent portals/cursors (between transactions)