Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 20:53:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I have not tested this, but I believe what is required is that an owner of the outer procedure has the execute right on the inner procedure with the grant option. I'm not aware of a requirement that "the owner and creator of the outer procedure be the same." Where did you get this? From a manual, an error message, or bitter experience? 8)

Creators are granted rights (with the grant option) on objects they create. But it's the owners that need the rights in the situation we're discussing. So if the owner is not also the creator, the creator needs to grant the right (with grant option) to the owner. Are you saying you did that and still had problems?

Jon

	<Prev	Next>		<<First	<Prev	Next>	Last>>