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