October 6, 2009 at 7:40 am
I have a linked Server form SQL Server 2005 to an Oracle Database connection.
I understand well the security configuration of the linked server, in that you can control access to the target server through the security apparatus of the linked server. All MS documentation I've been able to find is limited to this type of security discussion.
What I would like to know is
A) Can I grant non sysadmins access to view linked server definitions without making changes? If so, how so?
B) can I restrict who can call a Linked Server By Name without validation user on the target?
October 7, 2009 at 12:55 pm
brown9071 (10/6/2009)
I have a linked Server form SQL Server 2005 to an Oracle Database connection.I understand well the security configuration of the linked server, in that you can control access to the target server through the security apparatus of the linked server. All MS documentation I've been able to find is limited to this type of security discussion.
What I would like to know is
A) Can I grant non sysadmins access to view linked server definitions without making changes? If so, how so?
B) can I restrict who can call a Linked Server By Name without validation user on the target?
In linked server properties -- security tab look below at the login settings for "For logins NOT defined in the list above, connections will..." Set that to "Not be made". That will prevent anyone besides you from accessing the linked Oracle server.
October 7, 2009 at 1:03 pm
I understand how to control access to the linked target server. I want to hide the linked server to local users, or gratn them access to view the definitions of it without making changes to it.
October 7, 2009 at 2:57 pm
I'm pretty sure what AlexSQLForums suggested will work. Only those local logins listed in the mappings box can access the linked server.
Am I missing something in your request?
J.D.
October 8, 2009 at 1:10 pm
What about allowing SQL Server users the ability to view linked server configuration details without being sysadmins? Is that possible?
October 8, 2009 at 8:07 pm
Under SSMS he can't unless he is a member of sysadmin server role.
MJ
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply