Re: grant to all tables

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(at)yahoo(dot)com> wrote in message
> > news:20030121071754(dot)57684(dot)qmail(at)web40606(dot)mail(dot)yahoo(dot)com(dot)(dot)(dot)
> > > 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?
> > >