Archives of the TeradataForum

Message Posted: Wed, 18 Mar 2009 @ 12:33:17 GMT

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

Hi -

The owner referenced by user does not have /Create table/ with grant option. I see this error coming up for one my procedures - when I use it to rename a table in the other database. Procedure in database A (Owner and Creator) and table is in database B.

I am using dbc.sysexec to rename the table in database B.

I understand the error insert update delete with grant option but create table I have seen for the first time. Here nothing is related to the view and the table database.Can somebody explain this ?

Thank you -

Sachin

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