> > > I have another question about GRANT/REVOKE:
> > >
> > > grant <privilege[,privilege,...]>
> > > on <rel1>[,...<reln>]
> > > to [public | GROUP <group> | <username>]
> > > ^^^^^^^^^^^^^
> > > I don't know how to create a GROUP ?
> >
> > I believe that you use "CREATE USER groupname", and then can assign
> > privileges to that pseudo-user/group, and then add users to that
> > group. Have you tried that?
> postgres=> create user grupo;
> CREATE USER
> postgres=> grant all on tmp to grupo;
> CHANGE
> create user joe in group grupo;
> CREATE USER
> postgres=> grant select on tmp to group grupo;
> ERROR: non-existent group "grupo"
Can someone tell us how "groups" work? I'm not finding enough clues just
by looking in the parser, and haven't stumbled across it in the docs...
- Tom
