Archives of the TeradataForum
Message Posted: Wed, 18 Mar 2009 @ 12:33:17 GMT
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 -
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|