Re: Schema (namespace) privilege details

"Rod Taylor" <rbt(at)zort(dot)ca> writes:
> Will we be able to accomplish the equivelent of the below?

I think what you're depicting is the equivalent of a schema owner
dropping a table in his schema, right? Yes, I proposed allowing that,
but not granting the schema owner any other ownership rights over
contained tables. This is analogous to the way that ownership of a Unix
directory lets you rm a contained file ... but not necessarily alter
that file in any way short of rm'ing it.

> Yes, basically what we do now. I'm hoping to add the ability to
> enable a group (ROLES) to have ownership of items as well as users
> when I complete the other tasks I've set before myself.

That could be a good extension, but I think it's orthogonal to the
immediate issue...

regards, tom lane