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.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly