| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was |
| Date: | 2005-03-26 06:55:08 |
| Message-ID: | 20050326065508.GA30959@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Sat, Mar 26, 2005 at 01:35:20AM -0500, Tom Lane wrote:
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
> > Should we perhaps also propagate grant insert on a table to grant
> > select, update on dependent serial sequences?
>
> Doesn't really follow. That code is maintaining an invariant: the owner
> of a table owns the associated indexes, toast table, sequences, etc.
> There's no system-wide assumption that sequence privileges track table
> privileges.
I brought this up a few months ago. Tom, weren't your objections
based more on implementation concerns than on whether the idea
itself had merit?
http://archives.postgresql.org/pgsql-general/2004-10/msg00511.php
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-26 07:30:28 | Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was |
| Previous Message | Tom Lane | 2005-03-26 06:35:20 | Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | chamil wijenayake | 2005-03-26 07:11:19 | i want to find |
| Previous Message | Tom Lane | 2005-03-26 06:35:20 | Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was |