Thread: 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... > 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? > > 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
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? > > >
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