Cross database select from stored procedure

• Paul Farnell

  SSC Veteran

  Points: 208

  More actions

  December 11, 2009 at 9:43 am

  #135990

  I have a stored procedure that goes across to another database. My understanding is that you eneble cross database chaining and add the user into the database you are crossing to. However my stored procedure is complaining that ot does not have select permissions on the table. Any idea how to fix this ?

• sql_lock

  SSCrazy Eights

  Points: 9373

  More actions

  December 14, 2009 at 3:16 am

  #1091829

  You could use the "Execute As" function in the SP.

  This user would have existing on both servers and the relevant permissions to select/update/delete on the table(s) in the SP.