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.