Solved

DO - Stored Procedure - Execute as not working as exepcted

I am trying to get DO to create a SP and in it, it needs to be execute as caller,

but when it is getting built it is coming out as Owner

And it does need to be as Caller.

Best answer by sean-dataops

Hi Ash,

It looks like you are just missing an underscore in the execute_as property, so it’s not getting picked up.

You can refer to all the properties of a stored procedure as well as any other SOLE objects here.

Thanks,

Sean

Hi Ash,

It looks like you are just missing an underscore in the execute_as property, so it’s not getting picked up.

You can refer to all the properties of a stored procedure as well as any other SOLE objects here.

Thanks,

Sean

Thanks very much! Always the simple things that cause the most grief!

Sign up