Problem with Global Temp table

Database
Enthusiast

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
2 REPLIES
Enthusiast

Re: Problem with Global Temp table

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

Re: Problem with Global Temp table

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.