Post reply

PERMISSION PROBLEM

  • February 11, 2011 at 7:01 am

    #245109

    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

    #1289681

    kasi5a (2/11/2011)

    HI ALL

    I 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

    #1289685

    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