December 16, 2008 at 6:40 am
I was just wondering how a linked server login which is a sql login is manged to tight security for distributed queries. I have a link login by which some programmers use to insert data in different servers, but i assume all the users in differnt servers can also do as those permissions are given to link login. am i right?
Is there a way i give access to only programmers for the link login and restrict others from all the servers.
December 16, 2008 at 8:10 am
For Linked Server, you can use Impersonate Login or Mapped Login
so for 70-431 exam, they have couple questions
If you want to only give login App1 on Server1 to Server2
You create a linked server to Server2, map App1 to App2 login on Server2, and choose "Not Be Made" for all OTHER logins...
That seemed to be what you were asking?
December 16, 2008 at 2:48 pm
How can i use Impersonate login when am not using windows authentication. I have a sql login which links all the servers and i gave read and write access to that link login by which all the users can write to the databases. is there a way i can restrict some of them to write, its really critical.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply