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