Re: grant to all tables

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?
> >
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
> > http://mailplus.yahoo.com
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

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