Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was - Mailing list pgsql-hackers

From Michael Fuhr
Subject Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was
Date
Msg-id 20050326065508.GA30959@winnie.fuhr.org
Whole thread Raw
In response to Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was
List pgsql-hackers
On Sat, Mar 26, 2005 at 01:35:20AM -0500, Tom Lane wrote:
> Christopher Kings-Lynne <chriskl@familyhealth.com.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/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was
Next
From: Tom Lane
Date:
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was