Re: GRANT access rights on rows

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: GRANT access rights on rows
Дата
Msg-id 20060105090338.GA7321@wolff.to
обсуждение исходный текст
Ответ на Re: GRANT access rights on rows  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Список pgsql-novice
On Thu, Jan 05, 2006 at 09:53:52 +0100,
  "A. Kretschmer" <andreas.kretschmer@schollglas.com> wrote:
> am  05.01.2006, um  2:42:31 -0600 mailte Bruno Wolff III folgendes:
> > > I believe the conventional method of doing this is to create a view
> > > selecting all the rows you wish to make accessable, then to grant access
> > > to the view.
> >
> > And note that the view can use current_user which may be useful if different
> > users are supposed to see different rows.
>
> Can you explain this with a simple example?

For example you might include a user name as a column of a table and then
have a view that lets users only see rows where the username in a row
matches current_user.

В списке pgsql-novice по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: GRANT access rights on rows
Следующее
От: "Roland Giesler"
Дата:
Сообщение: Re: Best way to manage users