
> First, the syntax I had in mind:
> 
> CREATE GROUP name [ WITH [ SYSID id ] [ USER name1, name2, ... ] ]
> ALTER GROUP name WITH SYSID id      /* changes sysid */
> ALTER GROUP name ADD USER name1, name2, ...
> ALTER GROUP name DROP USER name1, name2, ...
> DROP GROUP name
> 
> Please protest now or hold your peace for at least one release. :)
>

I think a group can be interpreted somehow like a priviledge.
As such the statement to add or remove a user from a group 
would be a "grant" statement.

The standard mutters something about "role"s 
(again haven't looked it up) 
I don't like the word role instead of group, but maybe if there
is a standard we should use it.

Informix and Oracle use the keyword role for groups,
and use grant/revoke to administer them.

Andreas

Tue, 14 Dec 1999 10:39:29 +0100
Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>
Re: [HACKERS] Create Group
On Tue, 14 Dec 1999, Zeugswetter Andreas SB wrote:

> > CREATE GROUP name [ WITH [ SYSID id ] [ USER name1, name2, ... ] ]
> > ALTER GROUP name WITH SYSID id      /* changes sysid */
> > ALTER GROUP name ADD USER name1, name2, ...
> > ALTER GROUP name DROP USER name1, name2, ...
> > DROP GROUP name

> I think a group can be interpreted somehow like a priviledge.
> As such the statement to add or remove a user from a group 
> would be a "grant" statement.

Not really, at least not in our context. A group is a collection
("group") of users which can collectively be granted privileges. For
example, you can do grant select on your_table to group staff (even right
now).

> The standard mutters something about "role"s 
> (again haven't looked it up) 
> I don't like the word role instead of group, but maybe if there
> is a standard we should use it.
> 
> Informix and Oracle use the keyword role for groups,
> and use grant/revoke to administer them.

I suppose they have a slightly different underlying philosposhy then.
PostgreSQL already uses "group" all over the place, this is just a logical
extension which was missing.

-- 
Peter Eisentraut                  Sernanders vaeg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Tue, 14 Dec 1999 12:12:33 +0100 (MET)
Peter Eisentraut <e99re41@DoCS.UU.SE>
Re: [HACKERS] Create Group