Enable user access to all DBs and tables in MS SQL server managment I create a new user in MS SQL via MS SQL server managment in / SECURITY / LOGINS part.

User is set and can connect , however dispite the fact he see all databases he can get data just from one of them and from rest he can get just structure.

Is there some special settings to enable full access to specifc user to all DBs?
Thanks
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!