It's been discussed before and I think the current view point is that
* it's not compliant with sql standards.
* it can be worked around with stored procedures.
I think the demand comes from mysql converts (as mysql allows
non-standard grants). IIRC Oracle doesn't allow this (pretty sure up
through the 8,x releases anyway).
Robert Treat
On Fri, 2003-01-31 at 00:18, Bruce Momjian wrote:
>
> Actually, he wants to grant permissions on all tables at once. Is this
> a TODO item? Folks seem to want this.
>
> ---------------------------------------------------------------------------
>
> codeWarrior wrote:
> > It's in the postgreSQL docs SQL Reference under GRANT but basically --
> >
> > GRANT ALL ON tblNAME TO PUBLIC;
> >
> >
> > "CSN" <cool_screen_name90001@yahoo.com> wrote in message
> > news:20030121071754.57684.qmail@web40606.mail.yahoo.com...
> > > Is there a way to grant to all tables in a database
> > > with a single sql statement - such as:
> > >
> > > grant all on db.* to user;
> > >
> > > If not, how's it done?
> > >