July 18, 2018 at 3:00 pm
Hello experts,
I've run into an odd situation. Whenever I create a linked server on my dev db server, I see a database on it that I don't want. It is always the same database, which leads me to suspect that I unintentionally granted some permission that causes this database to appear in every linked server catalog.
Does anyone know how to find out why this happens, and how to fix it so that this database doesn't appear in the catalog unless I want it to?
Thanks for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 18, 2018 at 3:57 pm
webrunner - Wednesday, July 18, 2018 3:00 PMHello experts,I've run into an odd situation. Whenever I create a linked server on my dev db server, I see a database on it that I don't want. It is always the same database, which leads me to suspect that I unintentionally granted some permission that causes this database to appear in every linked server catalog.
Does anyone know how to find out why this happens, and how to fix it so that this database doesn't appear in the catalog unless I want it to?Thanks for any help.
- webrunner
How is the security setup for the linked servers?
Sue
July 19, 2018 at 9:37 am
Sue_H - Wednesday, July 18, 2018 3:57 PMwebrunner - Wednesday, July 18, 2018 3:00 PMHello experts,I've run into an odd situation. Whenever I create a linked server on my dev db server, I see a database on it that I don't want. It is always the same database, which leads me to suspect that I unintentionally granted some permission that causes this database to appear in every linked server catalog.
Does anyone know how to find out why this happens, and how to fix it so that this database doesn't appear in the catalog unless I want it to?Thanks for any help.
- webrunner
How is the security setup for the linked servers?
Sue
Thanks for your reply, Sue. The security is set to:
Be made using this security context:
Remote login
With password
Thanks again,
webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
July 19, 2018 at 11:05 am
webrunner - Thursday, July 19, 2018 9:37 AMSue_H - Wednesday, July 18, 2018 3:57 PMwebrunner - Wednesday, July 18, 2018 3:00 PMHello experts,I've run into an odd situation. Whenever I create a linked server on my dev db server, I see a database on it that I don't want. It is always the same database, which leads me to suspect that I unintentionally granted some permission that causes this database to appear in every linked server catalog.
Does anyone know how to find out why this happens, and how to fix it so that this database doesn't appear in the catalog unless I want it to?Thanks for any help.
- webrunner
How is the security setup for the linked servers?
Sue
Thanks for your reply, Sue. The security is set to:
Be made using this security context:
Remote login
With passwordThanks again,
webrunner
Anyone who uses that linked server has the permissions of the remote login. It gets a bit more complex as public had the view any database permission by default. If you still have that default permission, any login that can connect can see all databases on that instance. You would need to remove that permission from public on those instances if you don't want that behavior. Keep in mind though that sysadmin doesn't have any security checks. Hopefully that remote login is not a sysadmin so it won't matter.
Sue
July 20, 2018 at 6:43 am
is it possible that the login used in your linked server is the owner of the database that you are seeing ?
MVDBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply