| From: | Rafał Radecki <radecki(dot)rafal(at)gmail(dot)com> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | PostgreSQL 8.4 - permissions for newly created tables? | 
| Date: | 2013-06-20 10:54:41 | 
| Message-ID: | CAHd9_iQ+HzWmrNfK5-PN17ebc-g1FLpvhJWiPZMOdqjw2ZnLwQ@mail.gmail.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rafał Radecki | 2013-06-20 10:58:21 | Re: PostgreSQL 8.4 - permissions for newly created tables? | 
| Previous Message | Achilleas Mantzios | 2013-06-20 09:46:21 | Re: Why sequence grant is separated from table? |