On Monday 20 December 2010 11:46:29 am Carlos Mennens wrote:
> On Mon, Dec 20, 2010 at 1:32 PM, Scott Marlowe
wrote:
> > No user, no group, they're al roles. Roles are both / either.
>
> Ah now I understand. Thank you!
>
> > You grant them that:
> >
> > grant rolename to username;
> >
> > Then y
On Mon, Dec 20, 2010 at 1:32 PM, Scott Marlowe wrote:
> No user, no group, they're al roles. Roles are both / either.
Ah now I understand. Thank you!
> You grant them that:
>
> grant rolename to username;
>
> Then you only ever have to grant / revoke a role to change
> permissions, no need to d
On Mon, Dec 20, 2010 at 10:12 AM, Carlos Mennens
wrote:
> On Mon, Dec 20, 2010 at 12:05 PM, Scott Marlowe
> 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
>> L
On 12/20/2010 08:12 AM, Carlos Mennens wrote:
On Mon, Dec 20, 2010 at 10:41 AM, Adrian Klaver wrote:
Roles = users/groups. In older versions there where users and groups, that has
been consolidated into the concept of a role. If it makes it easier I use the
concept of roles with login privilege
On Mon, Dec 20, 2010 at 12:05 PM, Scott Marlowe 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
> ---+--
On Mon, Dec 20, 2010 at 9:12 AM, Carlos Mennens
wrote:
> So if I wanted to create a group / role for accounting, would I simply just
> do:
>
> CREATE ROLE accounting;
>
> My question is I can't find:
>
> 1. How to view all previously created roles on my database. '\dg'
> doesn't show me the new r
On Mon, Dec 20, 2010 at 10:41 AM, Adrian Klaver wrote:
> Roles = users/groups. In older versions there where users and groups, that has
> been consolidated into the concept of a role. If it makes it easier I use the
> concept of roles with login privileges as a users and roles without as groups.
On Monday 20 December 2010 7:27:19 am Carlos Mennens wrote:
> I was looking at my users and realized none of my users are members of
> a specific group or role. Not sure if there's a difference between the
> two (role / group) in PostgreSQL, is there?
>
> easports=# \du
>Lis
I was looking at my users and realized none of my users are members of
a specific group or role. Not sure if there's a difference between the
two (role / group) in PostgreSQL, is there?
easports=# \du
List of roles
Role name |Attributes | Member of
-
