From: | Yang Zhang <yanghatespam(at)gmail(dot)com> |
---|---|
To: | David Johnston <polobo(at)yahoo(dot)com> |
Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Default permissions for CREATE SCHEMA/TABLE? |
Date: | 2011-03-25 01:10:32 |
Message-ID: | AANLkTimLPGpcz6MsHGhQAT4iQE0VsW2VuVckA5WhoGUD@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Any luck if I'm still on 8.4?
On Thu, Mar 24, 2011 at 3:17 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:
> Keep in mind if you want to alter the GLOBAL privileges (i.e., the defaults)
> granted via PUBLIC you MUST NOT specify a schema.
>
> From what I can tell there is no way to associate a default owner different
> that the one executing the CREATE statement (though some inheritance cases
> do arise IIRC).
>
> David J.
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Stephen Frost
> Sent: Thursday, March 24, 2011 4:56 PM
> To: Yang Zhang
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Default permissions for CREATE SCHEMA/TABLE?
>
> * Yang Zhang (yanghatespam(at)gmail(dot)com) wrote:
>> Any way I can have all newly created schemas/tables be owned by, or
>> have all permissions granted to, a certain group, without having to
>> remember to GRANT ALL ON [SCHEMA|TABLE] TO that group? Thanks in
>> advance.
>
> ALTER DEFAULT PRIVILEGES FOR ROLE my_user IN SCHEMA my_schema GRANT SELECT
> ON TABLES TO other_role;
>
> http://www.postgresql.org/docs/9.0/static/sql-alterdefaultprivileges.html
>
> Thanks,
>
> Stephen
>
>
--
Yang Zhang
http://yz.mit.edu/
From | Date | Subject | |
---|---|---|---|
Next Message | Zheng Yang | 2011-03-25 02:07:11 | Re: foreign data wrappers |
Previous Message | Shiv | 2011-03-25 00:53:10 | Re: foreign data wrappers |