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