If you want only give access a 1 database (or only somethings )
1. It Doesn’t assign server role to user
2. Use tab Server Mappings to grant access to selected database using dbo schema

Advertisements