All Forums Database
sachinace 11 posts Joined 09/07
18 Mar 2009
The owner referenced by user does not have Create table with grant option

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 ?

Fred 1096 posts Joined 08/04
18 Mar 2009

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".

You must sign in to leave a comment.