Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL reference manual

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
Cc: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Re: PostgreSQL reference manual
Date: 1998-03-23 16:45:39
Message-ID: 351691B3.87C272A@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-hackers
> > > 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

pgsql-hackers by date

Next:From: The Hermit HackerDate: 1998-03-23 16:49:19
Subject: Re: [HACKERS] mega-patch--tcl/tk configuration
Previous:From: Zeugswetter AndreasDate: 1998-03-23 16:30:42
Subject: Re: [HACKERS] char types gone.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group