I have SQL Server, and I need to give access to other users to run basic queries (just select on 1 database).
I have created a login for a user, and have amended their permissions, but once I deny access to "Control Server" that login can no longer connect.
I am totally stuck as have no experience here, but must complete this task. Please can someone help with what the next step is?
p.s. it can't be hire someone that knows what they are doing :-)