Re: [pgsql-hackers] Allow GRANT/REVOKE permissions to be applied

I have added this syntax to the TODO list:

* Allow GRANT/REVOKE permissions to be applied to all schema objects with one command
 The proposed syntax is:       GRANT SELECT ON ALL TABLES IN public TO phpuser;       GRANT SELECT ON NEW TABLES IN
publicTO phpuser;
 


---------------------------------------------------------------------------

Matthias Schmidt wrote:
> Hi *,
> 
> I will start implementing this stuff based on this syntax:
> 
> GRANT SELECT ON ALL TABLES IN public TO phpuser;
> GRANT SELECT ON NEW TABLES IN public TO phpuser;
> 
> so there are two seperate commands to use.
> 
> is everybody fine with this aproach?
> 
> cheers,
> 
> Matthias
> 
> PS.: Tom, shouldn't we mention the fact, that one can grant on views 
> and sequences as well in the documentation?
> 
> 
> 
> Am 29.01.2005 um 01:43 schrieb Tom Lane:
> 
> > Josh Berkus <josh@agliodbs.com> writes:
> >> GRANT SELECT ON ALL, NEW TABLES IN public TO phpuser;
> >> ... does both.
> >
> > Ah, I overlooked that part of your message.  I think the above probably
> > doesn't work in bison, but if not we could spell it like
> >
> >   GRANT SELECT ON ALL AND NEW TABLES IN public TO phpuser;
> >
> > Or just make the user enter two commands for this case.  Aside from
> > syntactic simplicity, that might be a good idea anyway.  The NEW TABLES
> > case is *fundamentally* different from every other form of GRANT, in
> > that it causes future actions.  So it might be a wise idea from the
> > standpoint of understandability to keep it as a separate command from
> > the immediate-acting ALL TABLES.
> >
> >             regards, tom lane
> >
> > ---------------------------(end of 
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
> >
> ----------------------------------------------------------------------
> Matthias Schmidt
> Viehtriftstr. 49
> 
> 67346 Speyer
> GERMANY
> 
> Tel.: +49 6232 4867
> Fax.: +49 6232 640089
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073