| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl> |
| Cc: | "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Some things I like to pick from the TODO list ... |
| Date: | 2005-01-24 18:52:48 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A75D6@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > 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. 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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2005-01-24 19:13:25 | Proposed TODO: fetch->INT8 |
| Previous Message | Merlin Moncure | 2005-01-24 18:31:34 | userlock changes for 8.1/8.2 |