Hello experts,
I've created a remote login and a linked server and granted what I thought were the correct permissions to two databases on the remote server.
However, when I open up the linked server, I see an additional database listed. That is a real database on the same remote server, but I don't see where I would have added it to the linked server configuration. I checked the remote login and it does not have anything checked in the User Mapping screen.
At the same time, it doesn't show any Tables or Views, so it seems like a stray public or guest permission that somehow has this database in it.
Does anyone know where linked server catalog/permission data is stored so I can see why this database is showing, and how I can remove the remote login's permissions to it?
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
If the guest account is enabled in those databases, that's one thing that would allow those databases to show.
Sue
February 12, 2020 at 7:35 pm
Thanks, Sue, that was it!
I'm going to review our guest accounts to make sure no inappropriate ones are enabled or have connect permissions.
I disabled guest for the database in question with this command:
REVOKE CONNECT FROM guest
GO
https://blog.sqlauthority.com/2012/02/20/sql-server-disable-guest-account-serious-security-issue/
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply