Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sathiesh2005
Yak Posting Veteran
85 Posts |
 Posted - 2010-07-27 : 08:38:57
|
| Hi,I have created a linked server sqlserver2000. Is it possible to hide this from Enterprise manager?Or is it possible to hide the details of the linked server?the linked server may be visible to my login only.thanks.@Sathiesh |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-07-27 : 11:43:46
|
| I doubt because a Sysadmin have higher level of privilege and he can see all the linked server info. |
 |
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-07-27 : 23:56:42
|
| Hi pk_bohra,Thanks for your reply.No issues. a Sysadmin can see. i want to hide from other db users.@Sathiesh |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-28 : 11:05:49
|
| as long as you've used "login using the users current security context" in the security of the linked server, you have no worries. if you've hard-coded a username and password, it would be a good idea to rethink that. |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-07-30 : 05:51:00
|
| Hi Russell,thanks for reply.I am using "login using the users current security context" in the security(as like you mentioned). My thing is to hide the info. like what is the other server linked with this server. ie. Datasource.@Sathiesh |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-30 : 09:48:36
|
| if you haven't given them permission on the remote (linked) server then there is nothing to worry about. |
|
|
|
sathiesh2005
Yak Posting Veteran
85 Posts |
Posted - 2010-08-05 : 06:07:32
|
| thanks Russell. No issues now. finally i convinced my boss that we have no issues in this setups.@Sathiesh |
|
|
|
|
|
|
Is it possible to hide a linked server???