Enable user access to all DBs and tables in MS SQL server managment
Unless the user is given the system adminstrator (sa) role, you will need to add a user to each database which is mapped to the login and which gives the correct permissions just for that database.

Be very careful creating users with global access to databases, it is the start of a slippery slope to a major hack!