Re: Privileges and inheritance - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Privileges and inheritance
Date
Msg-id 17029.1254707653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Privileges and inheritance  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> On Sun, 2009-10-04 at 11:56 -0700, Josh Berkus wrote:
>> And we'd want to hammer this to death looking for ways it can be a
>> security exploit. Like, could you make a table into the parent of an
>> existing table you didn't have permissions on?

> I don't think so, but you're free to hammer. ;-)

I believe you have to be owner of both tables to do an ALTER INHERIT.
So you would have the right to make the child more accessible than it
had been.  Whether you realized you were doing that might be a bit
debatable ... but I don't seriously think this is a problem.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Rules: A Modest Proposal
Next
From: Alvaro Herrera
Date:
Subject: Re: Rules: A Modest Proposal