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, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly