Skip site navigation (1) Skip section navigation (2)

Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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/

In response to

Responses

pgsql-hackers by date

Next:From: chamil wijenayakeDate: 2005-03-26 07:11:19
Subject: i want to find
Previous:From: Tom LaneDate: 2005-03-26 06:35:20
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was

pgsql-committers by date

Next:From: Tom LaneDate: 2005-03-26 07:30:28
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was
Previous:From: Tom LaneDate: 2005-03-26 06:35:20
Subject: Re: [COMMITTERS] pgsql: Fix two bugs in change_owner_recurse_to_sequences: it was

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group