February 11, 2011 at 7:01 am
HI ALL
I AM HAVING SOME PROBLEM AND DOUBT..
EXEC SP_EXECUTESQL @BUILDTABLESTR IS THERE ANY PERMISSION TO OTHERS??? TO EXEC THIS QUERY?????
February 21, 2011 at 9:27 pm
kasi5a (2/11/2011)
HI ALLI AM HAVING SOME PROBLEM AND DOUBT..
EXEC SP_EXECUTESQL @BUILDTABLESTR IS THERE ANY PERMISSION TO OTHERS??? TO EXEC THIS QUERY?????
SP_EXECUTESQL requires membership in the public role. What @BUILDTABLESTR is trying to do? Permission issue is more likely caused by actions inside that code. Can you show us that code?
February 21, 2011 at 10:40 pm
EXEC SP_EXECUTESQL @BUILDTABLESTR
like John mentioned, you need to look into your query which you passing into variable. There might be some object/s in query on which the user do not have permission.
----------
Ashish
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply