> 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