All Forums Database
Arun sankar 12 posts Joined 04/07
23 Nov 2009
Problem with Global Temp table

Hi,I have a set of global temp tables. I have views built on top of it. When i tried to use them in my stored procedure. I got a error message Error 3523: An owner referenced by user does not have INSERT WITH GRANT OPTION A couple of tables works well. I have the views built on the same database where i am creating the stored procedure. Please let me know what could be the problem.Thanks,Arun

pawan0608 101 posts Joined 12/07
23 Nov 2009

I think, the first thing, the Creator of the views should have privilege WITH GRANT option

Jimm 298 posts Joined 09/07
23 Nov 2009

The database with the stored procedure needs Select/ Insert/ Update and delete (if used in the proc) with Grant option on the database containing the views.

You must sign in to leave a comment.