Skip site navigation (1) Skip section navigation (2)

Re: grant to all tables

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: codeWarrior <gpatnude(at)hotmail(dot)com>,"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: grant to all tables
Date: 2003-01-31 21:41:03
Message-ID: 1044049263.6685.59.camel@camel (view raw or flat)
Thread:
Lists: pgsql-general
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?
> > >




In response to

pgsql-general by date

Next:From: Dmitry TkachDate: 2003-01-31 22:07:43
Subject: Re: Query performance PLEASE HELP
Previous:From: Robert TreatDate: 2003-01-31 21:29:40
Subject: Re: using pgcrypt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group