Re: Proposal : changing table ownership - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: Proposal : changing table ownership
Date
Msg-id Pine.BSF.4.21.0009081153520.493-100000@thelab.hub.org
Whole thread Raw
In response to Re: Proposal : changing table ownership  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, 8 Sep 2000, Tom Lane wrote:

> "Mark Hollomon" <mhh@nortelnetworks.com> writes:
> > ALTER TABLE <table> OWNER TO <newowner>
> 
> > The owner of a table will be able to change the owner to any other user.
> 
> Doesn't this create risks parallel to file give-away (chown) in Unix?
> A lot of Unices disallow chown except to the superuser.

Agreed ...

> Tables aren't currently active objects, but we've been talking about
> things like making trigger functions run "setuid" to the table owner.
> If that happens then table ownership giveaway is a big security hole.
> 
> > The superuser will NOT have special privileges.
> 
> Say *what* ?  That's just silly.

*Only* superuser should be able to run the above command ... 



pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [7.0.2] node type 17 not supported ...
Next
From: The Hermit Hacker
Date:
Subject: Re: [7.0.2] node type 17 not supported ...