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

From Andreas Pflug
Subject Re: Some things I like to pick from the TODO list ...
Date
Msg-id 41F6B7AF.4090800@pse-consulting.de
Whole thread Raw
In response to Re: Some things I like to pick from the TODO list ...  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Responses Re: Some things I like to pick from the TODO list ...
List 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


pgsql-hackers by date:

Previous
From: Luiz Gonzaga da Mata
Date:
Subject: Performance of the temporary table creation and use.
Next
From: Tom Lane
Date:
Subject: Re: userlock changes for 8.1/8.2