Saturday, February 25, 2012

SQL Server user can access all databases issue

Following are the steps to resolve this issue.


1. Go to user's properties:






2. Go to user mappings:
    2.1. check the default database for login.
    2.2. check db_owner in database role membership. 













3. click default schema button
    3.1. type dbo and click on.



4. click server roles and confirm uncheck of sysadmin permissions.