On Mon, Dec 20, 2010 at 10:12 AM, Carlos Mennens
<carlos.mennens@gmail.com> wrote:
> On Mon, Dec 20, 2010 at 12:05 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> Odd, mine does. Got a complete example of creating a role and not seeing it?
>>
>> Here's mine:
>> smarlowe=# create role stans;
>> CREATE ROLE
>> smarlowe=# \dg
>> List of roles
>> Role name | Attributes | Member of
>> -----------+--------------+-----------
>> postgres | Superuser | {}
>> : Create role
>> : Create DB
>> smarlowe | Superuser | {}
>> : Create role
>> : Create DB
>> stans | Cannot login | {}
>
> I guess I am still confused by role / group & user accounts. If you
No user, no group, they're al roles. Roles are both / either.
> create a role / group called 'finance', it then shows up as a user
> when I do \dg? Then how do I make users a member of the 'finance' role
Yep, it shows up as a ROLE.
> / group if they're listed just like regular users are?
You grant them that:
grant rolename to username;
Then you only ever have to grant / revoke a role to change
permissions, no need to do a million grants all over the place on each
table. Just grant it once to the role, grant the role to the user,
viola, you're done.
>
> easports=# CREATE ROLE finance;
> CREATE ROLE
> easports=# \dg
> List of roles
> Role name | Attributes | Member of
> -----------+-----------------------------------+-----------
> cmennens | Superuser | {}
> finance | Cannot login | {}
> postgres | Superuser, Create role, Create DB | {}
>
> From the above listing, I would expect 'finance' to not be listed with
> my users since finance is a role / group, not a single user. I want to
> make specific users members of 'finance'. Am I missing something or
> just slow today?
>
>>> 2. How to see which 'users' are all members of 'accounting'? Would
>>> that be done simply with '\dg'?
>>
>> Yeah.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
To understand recursion, one must first understand recursion.
