Re: grant the right to select only certain rows?

Why not create a view and grant her access to the view?

Greg

----- Original Message -----
From: "Fran Fabrizio" <ffabrizio(at)mmrd(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, January 25, 2002 12:04 PM
Subject: [GENERAL] grant the right to select only certain rows?

>
> If I have a table students:
>
> name grade_level
> Joe 1
> Kim 1
> Lisa 2
> Mike 2
>
> 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? I think GRANT only works as a
> table-wide permission, but a co-worker thinks he has seen similar
> behavior in Oracle, like
> "GRANT SELECT AS SELECT * FROM STUDENTS WHERE grade_level = 1
> ON students FOR USER mary_smith" (Rough approximation of the type of
> query I am looking for).
>
> Thanks,
> Fran
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>