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

Re: Some things I like to pick from the TODO list ...

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>,Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Some things I like to pick from the TODO list ...
Date: 2005-02-01 04:54:32
Message-ID: 200502010454.j114sW929053@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Andreas Pflug wrote:
> Merlin Moncure wrote:
> >>>3) Allow GRANT/REVOKE permissions to be applied to all schema
> > 
> > objects
> > 
> >>>with one
> >>
> >>Maybe this is "apply schema changes to several objects with one
> >>command".  This seems reasonable.
> > 
> > 
> > Well, I don't know.  IMO, what I would really like to see is for various
> > database objects to inherit permissions from the schema.  The ability to
> > GRANT to all tables in a schema, etc. is almost trivial to implement in
> > plpgsql/dynamic sql currently. 
> 
> And pgAdmin3 V1.2 has the Grant Wizard, as pgAdmin2 had. Though an SQL 
> command for granting on multiple objects won't hurt.
> 
> > However the major annoyance with that
> > approach is that I have to remember to re-grant permissions to tables in
> > a schema after running that function.  As worded, the TODO does not
> > solve that problem.
> > 
> > IOW, I would really like to see the TODO to be reworded 'allow schema
> > objects to inherit permissions from the schema' or something like
> > this...
> 
> This sounds quite helpful too, but I'd call it a second TODO.

Added to TODO:

	* Allow GRANT/REVOKE permissions to be inherited by objects based on
	  schema permissions

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-02-01 04:56:38
Subject: Re: Proposed TODO: fetch->INT8
Previous:From: Tom LaneDate: 2005-02-01 03:45:08
Subject: Re: [Feed-back] Installing PostgreSQL 8.0.0 on SPARC/Solaris. Configure and install issues.

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