From: | KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | Andrew Sullivan <ajs(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Updates of SE-PostgreSQL 8.4devel patches |
Date: | 2008-10-16 00:31:00 |
Message-ID: | 48F68B44.8010002@ak.jp.nec.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Bruce Momjian wrote:
> KaiGai Kohei wrote:
>> Bruce Momjian wrote:
>>> I think we could use row-level access control to prevent people from
>>> seeing databases they should not see in pg_database.
>> The row-level database ACL which I submitted yesterdat does not allow
>> to assign ACLs to tuples within system catalogs (like pg_database),
>> because it is unclear who should be the owner of tuples.
>>
>> As I noted at the previous message, it considers the owner of the table
>> as the owner of the tuples due to several reasons. However, some of system
>> catalogs have its owner field like "pg_proc.proowner".
>> This limitation is not a fundamental one, so we can remove it soon.
>>
>> But, who should be the owner of tuples within system catalogs which have
>> some kind of "owner" field.
>
> The Postgres super-user should be the owner of all system tables.
OK, I'll update it soon.
--
OSS Platform Development Division, NEC
KaiGai Kohei <kaigai(at)ak(dot)jp(dot)nec(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | ITAGAKI Takahiro | 2008-10-16 01:14:08 | Re: contrib/pg_stat_statements |
Previous Message | Ian Caulfield | 2008-10-15 23:33:28 | array_agg (was Re: The Axe list) |