Home Forums SQL Server 2008 SQL Server Newbies Do Users based on logins in master have access to other databases? RE: Do Users based on logins in master have access to other databases?

  • March 15, 2013 at 12:45 am

    #1597358

    If you create a login and set 'master' as default database then, the user will only be created in the master database. The login/user will not have access to any of the user/system databases untill and unless you map the user to other databases. Upon trying to access any other database it should result into the belwo error:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

    The database 'MyUserDB' is not accessible. (ObjectExplorer)

    ------------------------------