Hi I created a linked server. --------------------------------- type : sql server local Login : login1 Remote user & remote password : (Case 1 : empty - Case 2 : = login1) be made using this sequrity content : login1 passlogin1 --------------------------------- Problem : Any login in server1 (that server has linked server) has all access on linked server (all databases on it)!!!!!! that means : if any user with least access, knows only knows linked server name and a database name on it, it can select any data from that database whitout any formal access. please help me. I should protect linked server data, from local user in server1. thank you.
If you right-click on your linked server inside SSMS and bring up the Properties->Security, there are a variety of ways to limit/define the security. You can define an explicit list of people who can make use of the linked server. You can define an explicit login to use; this login could have few or many rights depending on your objective. You can define it so that each user uses their own security context in wich case the amount of trouble they can get into is limited by the set of rights they have been granted. You can also define it so that they login using no security context. I have no idea what that option actually means.
================================================= We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
serious problem in linked server security
Posted - 10/29/2012 : 04:42:45
