| Author |
Topic |
|
Ginger8990
Starting Member
28 Posts |
 Posted - 2015-01-29 : 11:33:13
|
| we need to grand some users only read access to SQL DB but I am not sure whether I can remove/delete linked server under server object from SQL native client.If I delete linked server from sql client, do I just delete the whole thing from SQL server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-29 : 12:27:15
|
| I'm confused why you mentioned the read access when the question is about deleting a linked server. What am I missing?In object explorer in SSMS, just right click on the linked server and delete it. Please note that this is a server object and is not specific to a user. Deleting it deletes it for everyone.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Ginger8990
Starting Member
28 Posts |
Posted - 2015-01-29 : 12:39:14
|
Actually it is relevant. IF you grand user read only access, you don't want them to see the linked sql server.So that means deletion of sql linked server will be deleted on SQL server, too.Thanks!quote:
Originally posted by tkizer
I'm confused why you mentioned the read access when the question is about deleting a linked server. What am I missing?In object explorer in SSMS, just right click on the linked server and delete it. Please note that this is a server object and is not specific to a user. Deleting it deletes it for everyone.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-29 : 12:43:03
|
| No it's not relevant if the security is setup correctly. How is the linked server configured regarding security?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Ginger8990
Starting Member
28 Posts |
Posted - 2015-01-29 : 14:04:04
|
quote:
Originally posted by tkizer
No it's not relevant if the security is setup correctly. How is the linked server configured regarding security?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
By default, connection Not be made. so we use default options for linked server. But they can see all linked servers with IP addresses. Is there a way to hide it from all common users? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-29 : 14:23:58
|
| Unless you play around with revoking permissions to system objects, I don't see a way around users being able to see the linked server. Seeing the linked server doesn't mean they can use it. Sounds like the linked server is setup correctly to not allow most to use it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Ginger8990
Starting Member
28 Posts |
Posted - 2015-01-29 : 19:29:23
|
quote:
Originally posted by tkizer
Unless you play around with revoking permissions to system objects, I don't see a way around users being able to see the linked server. Seeing the linked server doesn't mean they can use it. Sounds like the linked server is setup correctly to not allow most to use it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
No, I didn't paly around with system object, what are you talking about, don't make assumtion if you don't know. Just answer the question you know. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-01-29 : 19:38:50
|
quote:
Originally posted by Ginger8990
No, I didn't paly around with system object, what are you talking about, don't make assumtion if you don't know. Just answer the question you know.
You misunderstood my last reply. I am saying that likely the only way to achieve what you want is to update permissions on the respective system objects. But I would not recommend it. I would just live with the fact that they can see it but can't use it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2015-02-02 : 10:09:01
|
Dear User,Please be polite when you reply to someone here.Thanksquote:
Originally posted by Ginger8990
quote:
Originally posted by tkizer
Unless you play around with revoking permissions to system objects, I don't see a way around users being able to see the linked server. Seeing the linked server doesn't mean they can use it. Sounds like the linked server is setup correctly to not allow most to use it.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/
No, I didn't paly around with system object, what are you talking about, don't make assumtion if you don't know. Just answer the question you know.
Javeed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
|
|
|
|
linked SQL server