Post reply

Having Trouble Granting Access to a Table for a User Through Linked Server

  • September 15, 2016 at 9:14 am

    #400731

    I have created user MySQLUser in Instance1. On Instance2 I have created a Linked Server Object to Instance1 and granted access to certain tables on one database. On Instance1 I modified the user by adding access to an extra table. However, on the Linked Server Object on Instance2 I still can't see that new table. Is there something else I need to do that I don't know about?

    Thanks.

    Steve

  • September 15, 2016 at 9:42 am

    #1901159

    I don't know exactly what you mean with "see", but you mean what you see when you expand nodes in SSMS, please attempt to run queries from a query window instead, so we know what is going on.

    When you access a remote instance through a linked server, there is no difference from when you access the remote server directly. That is, your local server is just another client as far as the other instance is concerned.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

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

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