Re: Some things I like to pick from the TODO list ... - Mailing list pgsql-hackers

From Merlin Moncure
Subject Re: Some things I like to pick from the TODO list ...
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3412A75D6@Herge.rcsinc.local
Whole thread Raw
In response to Some things I like to pick from the TODO list ...  (Matthias Schmidt <schmidtm@mock-software.de>)
Responses Re: Some things I like to pick from the TODO list ...  (Andreas Pflug <pgadmin@pse-consulting.de>)
List 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...





pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: userlock changes for 8.1/8.2
Next
From: "Merlin Moncure"
Date:
Subject: Proposed TODO: fetch->INT8