I was asked to provide access to windows user for only User databases in server. I added this user to db_reader role in all databases after creating login in Server. But here is the problem, this user can able to access System databases
even I have n't assign any role for this login in system databases. Your response will be helpful to fix this . Please let me know if I am missing here to understand it.
View Complete Post