From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | codeWarrior <gpatnude(at)hotmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: grant to all tables |
Date: | 2003-01-31 05:18:20 |
Message-ID: | 200301310518.h0V5IKv10348@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-01-31 05:19:22 | Re: ERROR: Unable to transform targetlist (internal error) |
Previous Message | codeWarrior | 2003-01-31 05:15:41 | Re: Basic SQL join question |