Linked Server/RPC Permissions

  • Situation:

    User Bob is executing stored procedure SP1 on Server Sv1. SP1 is owned by Mike. (Mike granted Bob execute permission on SP1)

    SP1 makes a remote procedure call to stored procedure RP2 on Server SV2. Mike has been granted execute permission on RP2. Mike has Login privileges to SV2 (Bob does not).

    Given that the servers SV1 & SV2 are linked by "the local login's user credentials when connecting to the linked server on behalf of the login", can Bob execute SP1? Under who's security context is the link made, Mike's or Bob's?

  • Stop you lost me at situation.

    Answer: Yes, Mike.

    Of cousrse I had to go test it before I said that.

    John Zacharkan

    Edited by - zach_john on 02/04/2003 1:07:26 PM


    John Zacharkan

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

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