Re: Read/Write restriction mechanism

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Read/Write restriction mechanism
Дата
Msg-id 682407E1-7FCC-45A7-810D-1F78CDDA105D@seespotcode.net
обсуждение исходный текст
Ответ на Read/Write restriction mechanism  (Naz Gassiep <naz@mira.net>)
Список pgsql-general
On Jan 9, 2008, at 1:39 , Naz Gassiep wrote:

> In a PHP project I have several functions that I use for DB
> operations. I only want to allow one of them to write, all the
> others are for reading only.


> (Using DB level perms are out, as this is the function usage I'm
> trying to control, not the connections).

Um, why are DB-level permissions out? It seems like a natural fit:
your writer connects as one role while the readers connect as
another. Only grant SELECT access to the readers.

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: "Harald Armin Massa"
Дата:
Сообщение: Re: count(*) and bad design was: Experiences with extensibility
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Startup scripts - Use -m fast or smart?