Re: grant the right to select only certain rows?

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