Thread: grant to all tables

grant to all tables

From
CSN
Date:
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

Re: grant to all tables

From
"codeWarrior"
Date:
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



Re: grant to all tables

From
Bruce Momjian
Date:
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

Re: grant to all tables

From
Robert Treat
Date:
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?
> > >




Re: grant to all tables

From
"Williams, Travis L, NPONS"
Date:
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