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@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?
> >
> > __________________________________________________
> > 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@postgresql.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073