Re: [PATCHES] Users/Groups -> Roles

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [PATCHES] Users/Groups -> Roles
Date: 2005-06-30 12:54:22
Message-ID: 20050630125422.GA29327@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 30, 2005 at 13:39:09 +0200,
Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr> wrote:
>
> The standard talks about 2 distinct concepts: USER and ROLE (4.34). I'm
> not sure it is a good idea to drop the user concept to replace it by role.
> If you do so, you may miss something about what roles are about.

I think it is a good idea to make users synonymous with roles with
regard to privileges. This will make checking for access simpler
and mistakes less likely. The special part of being a user in addition
to a role is that being a user allows for authentication.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2005-06-30 13:05:20 Re: [PATCHES] Users/Groups -> Roles
Previous Message Tom Lane 2005-06-30 12:46:48 Re: Open items