Re: Some things I like to pick from the TODO list ...

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>
Cc: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Some things I like to pick from the TODO list ...
Date: 2005-01-25 21:18:39
Message-ID: 41F6B7AF.4090800@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

Regards,
Andreas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-01-25 21:22:25 Re: [HACKERS] userlock changes for 8.1/8.2
Previous Message Simon Riggs 2005-01-25 21:03:50 Re: Autotuning Group Commit