[HACKERS] Owner inheritance

2010-12-21 Thread gsdfg gdfg
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. Michel

Re: [HACKERS] Owner inheritance

2010-12-21 Thread Tom Lane
gsdfg gdfg mx.mo...@gmail.com 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

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