SELECT INTO tempdb..

External Since: Oct 14, 2005 Posts: 4

I have tested a stored procedure that SELECT INTO tempdb..myAppTable in
development as an user who has dbo rights. Hence, the table can be
referenced as tempdb.dbo..myAppTable.

However, when the same stored procedure is run in production as a user
who has only guest role, the same table can only be referenced as
tempdb.guest.myAppTable.

Can the SELECT INTO be modified so the dbo has table ownership?

External Since: Dec 09, 2005 Posts: 8

On production you can probably assign to guest a dbo role but that
obviously would not be a good idea. It is probably better and more
accurate to have him test on development as guest rather than dbo. The
purpose of dev is to simulate production in all possible ways.

Patrick