grant the right to select only certain rows?
| От | Fran Fabrizio |
|---|---|
| Тема | grant the right to select only certain rows? |
| Дата | |
| Msg-id | 3C51900B.D3C0DA36@mmrd.com обсуждение исходный текст |
| Ответы |
Re: grant the right to select only certain rows?
Re: grant the right to select only certain rows? Re: grant the right to select only certain rows? |
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: