PostgreSQL 8.4 - permissions for newly created tables?

Поиск
Список
Период
Сортировка
От Rafał Radecki
Тема PostgreSQL 8.4 - permissions for newly created tables?
Дата
Msg-id CAHd9_iQ+HzWmrNfK5-PN17ebc-g1FLpvhJWiPZMOdqjw2ZnLwQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL 8.4 - permissions for newly created tables?  (Rafał Radecki <radecki.rafal@gmail.com>)
Список pgsql-admin
Hi All.

I have to setup a new infrastructure with postgre software. I would like to use user access patterns from mysql if possible. For every application:
1) one user for reads: grant select on db.* to 'reader'@'ip space' ...;
2) one user for reads/writes: grant update,insert,select,delete on db.* to 'writer'@'ip space' ...;
3) every user comes from a defined IP address space.
I would like to give one postgre db to one application.
1) and 2) - Is it really necessary to give permissions for newly created tables for such users every time a table is created (I am using 8.4, not 9.X)?
3) I think that kind of functionality is best to accomplish with pg_hba.conf?
I also would like to give ALL database for newly created application database rights for a lead programmer, so then he/she could give permissions for newly created objects to reader/writer application roles.

Is it the best way? Any hints?

Best regards,
Rafal Radecki.

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

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Why sequence grant is separated from table?
Следующее
От: Rafał Radecki
Дата:
Сообщение: Re: PostgreSQL 8.4 - permissions for newly created tables?