I want to grant read access to a single table only for 1x user.
I run this:
GRANT SELECT ON [mydb].[dbo].[mytable] TO [abc\mynewuser];
When I view Security > Users, the icon shows a red down arrow next to mynewuser (which I believe is due to the user not having CONNECT access?)
I'm guessing I need to tweak something at the Server > Security > Logins level?