grant to all tables
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
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...
Show quoted text
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
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?
--
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
It's been discussed before and I think the current view point is that
* it's not compliant with sql standards.
* it can be worked around with stored procedures.
I think the demand comes from mysql converts (as mysql allows
non-standard grants). IIRC Oracle doesn't allow this (pretty sure up
through the 8,x releases anyway).
Robert Treat
Show quoted text
On Fri, 2003-01-31 at 00:18, Bruce Momjian wrote:
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?
Is there a way you could have a group (lets say called common, something
editable) and you could set permissions on that group (not on the table)
and these permissions would span across all tables including new tables
by default?
Travis
-----Original Message-----
From: Robert Treat [mailto:xzilla@users.sourceforge.net]
Sent: Friday, January 31, 2003 3:41 PM
To: Bruce Momjian
Cc: codeWarrior; pgsql-general@postgresql.org
Subject: Re: [GENERAL] grant to all tables
It's been discussed before and I think the current view point is that
* it's not compliant with sql standards.
* it can be worked around with stored procedures.
I think the demand comes from mysql converts (as mysql allows
non-standard grants). IIRC Oracle doesn't allow this (pretty sure up
through the 8,x releases anyway).
Robert Treat
On Fri, 2003-01-31 at 00:18, Bruce Momjian wrote:
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?
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Import Notes
Resolved by subject fallback