• Yes. The login by default is a member of the public server role, which by default is granted the VIEW ANY DATABASE server permission.

    If you don't want this to be the case, you can run an explicit deny against that login:-

    DENY VIEW ANY DATABASE TO [YourLogin].

    Following this, the login will only be able to see the master, tempdb databases along with any databases that the login owns.

    More reading:- http://msdn.microsoft.com/en-us/library/ms189077.aspx

    Follow me on twitter @EvoDBACheck out my blog Natural Selection DBA[/url]