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