From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Question About Roles |
Date: | 2014-07-02 14:58:51 |
Message-ID: | 1404313131819-5810198.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Rich Shepard wrote
> On Wed, 2 Jul 2014, David G Johnston wrote:
>
>> or if you want to do it as part of creating a new user:
>>
>> CREATE ROLE new_management_user
>> [other stuff here]
>> IN ROLE management;
>>
>> http://www.postgresql.org/docs/9.2/interactive/sql-createrole.html
>
> David,
>
> I'll have to think deeply about what this is doing. Initially, I read
> it
> as assigning a new user's role to an existing group's role; that's the
> opposite of what I want.
Its the exact same outcome Tom provided, just via a different mechanism...
You want to assign all permissions to the standard group-roles and then have
new users inherit the appropriate permissions via their membership in the
appropriate group-role.
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Question-About-Roles-tp5810176p5810198.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Arup Rakshit | 2014-07-02 15:02:36 | Re: How can I replace the year of the created_at column with the current year dynamically ? |
Previous Message | Rich Shepard | 2014-07-02 14:57:24 | Re: Question About Roles |