The owner referenced by user does not have Create table with grant option
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 ?
Re: The owner referenced by user does not have Create table with grant option
The stored procedure is in effect attempting to convey the right to rename tables in database B to a third party calling the SP. So A must hold the necessary rights (i.e. CREATE TABLE) on B "WITH GRANT OPTION".