Owner inheritance

gsdfg gdfg <mx.morin@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 "chown" to non-superusers. Read up on the security
pitfalls of being able to give away ownership of an object.

regards, tom lane

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
CONTAINER, or just OWNER TO SCHEMA etc might be clearer). And I think
we'd have to restrict it to superusers anyway, which would seriously
limit its usefulness.

cheers

andrew