From: | Rafał Radecki <radecki(dot)rafal(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: PostgreSQL 8.4 - permissions for newly created tables? |
Date: | 2013-06-20 10:58:21 |
Message-ID: | CAHd9_iTxq66D-qehowudqQZZUJDK1pEv+AWJQ9_J4cbJLyXxrw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I can also make this lead programmer an owner of the newly created database
instead of giving him ALL permissions. "owner" is better than "all"?
2013/6/20 Rafał Radecki <radecki(dot)rafal(at)gmail(dot)com>
> 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 | bricklen | 2013-06-20 14:33:57 | Re: excessive WAL activity |
Previous Message | Rafał Radecki | 2013-06-20 10:54:41 | PostgreSQL 8.4 - permissions for newly created tables? |