Post reply

how to run a store proceedure in another user's context

  • September 22, 2011 at 10:22 am

    #244215

    Hi,

    I have a SQL 2005 stored procedure that calls .Net clr procedure that read that call a SSRS report, generate a PDF and save it under a directory.

    The procedure runs fine under user credidential userA which has necessary rights on the folder.

    The challenge is to call the stored proceedure in a scheduled job to run successfully.

    I have

    1)modfied the procedure to 'execure as 'userA'

    2)I have also configured the step in the job to run as 'userA'

    3) execute as user = 'userA; exec the_procedure

    without any success.

    Grateful if any of you could please advise on the solution.

    Thank you very much in advance

  • September 22, 2011 at 10:45 am

    #1385315

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1179576-359-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply