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

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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073