Re: [HACKERS] Owner inheritance

2010-12-21 Thread Andrew Dunstan
On 12/21/2010 07:04 AM, gsdfg gdfg wrote: Would be great if owner can be inherited from parent object (owner table ==> schema owner ==> database owner). CREATE statement could add OWNER TO PARENT to cover this feature. That syntax would violate POLA in the case of inherited tables (OWNER TO

Re: [HACKERS] Owner inheritance

2010-12-21 Thread Tom Lane
gsdfg gdfg writes: > Would be great if owner can be inherited from parent object (owner table ==> > schema owner ==> database owner). > CREATE statement could add OWNER TO PARENT to cover this feature. What it would be is a great security hole --- exactly analogous to allowing Unix "chown" to non