From: | Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | PgHacker <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [sepgsql 2/3] Add db_schema:search permission checks |
Date: | 2013-04-02 18:22:56 |
Message-ID: | CADyhKSVULwuQEe9Z1YH0U-SeTMye8K_WWi1NRV0xLOA_R7ATqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
2013/4/1 Robert Haas <robertmhaas(at)gmail(dot)com>:
> On Tue, Jan 15, 2013 at 3:28 PM, Kohei KaiGai <kaigai(at)kaigai(dot)gr(dot)jp> wrote:
>> This patch adds sepgsql support for permission checks equivalent
>> to the existing SCHEMA USE privilege.
>>
>> This feature is constructed on new OAT_SCHEMA_SEARCH event
>> type being invoked around pg_namespace_aclcheck().
>> So, its expected behavior also follows the behavior of existing
>> permissions; unprivileged schema is ignored from the search path,
>> or raise an error if object name is fully qualified.
>>
>> This patch needs src/backend/catalog/objectaccess.c is existing,
>> so please apply this patch on top of this feature.
>> https://commitfest.postgresql.org/action/patch_view?id=1003
>
> KaiGai,
>
> Could you please rebase this patch?
>
OK, please check the attached ones.
Both patches were rebased to the latest master branch, thus, once either
of them got committed, another one has to be rebased later.
Please also pay attention security policy module for regression test was
also adjusted for these features.
Thanks,
--
KaiGai Kohei <kaigai(at)kaigai(dot)gr(dot)jp>
Attachment | Content-Type | Size |
---|---|---|
sepgsql-v9.3-schema-search-permission.v3.patch | application/octet-stream | 45.9 KB |
sepgsql-v9.3-function-execute-permission.v3.patch | application/octet-stream | 23.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2013-04-02 18:40:19 | Re: Drastic performance loss in assert-enabled build in HEAD |
Previous Message | Merlin Moncure | 2013-04-02 18:11:51 | Re: Page replacement algorithm in buffer cache |