You would have to create a login for the user for them to connect to the server, then creating the user gives them permission to connect to the database.