Showing posts with label sql permission. Show all posts
Showing posts with label sql permission. Show all posts

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.