SQL Server User Mapping - Limit view of databases for a user
- by Jaime
Hi there,
I am adding a new Login with SQL Server Authentication. I set its Server Role as public and then went into User Mapping, selecting the only database this user should have access to. I then change the Default Schema to dbo and made this user the db_owner.
I then connect to the instance using the new user's credentials and I can see not only the database he should have access to but all the other attached databases.
How can I limit this user to just see the database he has access to?
Thanks in advance!