Re: grant to all tables

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(at)users(dot)sourceforge(dot)net]
Sent: Friday, January 31, 2003 3:41 PM
To: Bruce Momjian
Cc: codeWarrior; pgsql-general(at)postgresql(dot)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(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?
> > >

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org