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?

  • GilaMonster (3/19/2013)


    clintonG (3/19/2013)


    kevaburg (3/18/2013)


    lol!

    I don't know what's supposed to be so funny. How else could somebody lock down a Windows 7 client OS functioning as a "server" than to use Group Policy Editor?

    Start by making sure that 3/4 of the staff don't have the administrator password. Strong administrator password, limited user access with minimal permissions. Not talking about group policy, talking about restricting logins in the first place. Unless someone has a need to administer the particular machine, they should have no rights whatsoever to the machine.

    Once you've limited the access to just the few people who need to administer the machine, then you can do a proper lock down and harden if necessary.

    I'm deleting Guest and I wasn't planning on giving anybody the sa. I'll also change the sa password to a GUID. I'm installing SQLExpress and if they want an sa they can install another instance themselves or hire me to build other instances.

    I am concerned with a dilemma that requires the .mdf and logs in a share at My Documents > My Data folder so the ClickOnce LightSwitch apps (Silverlight clients) can be updated with a newer ClickOnce instance if needed. That is actually the same share I referred to in earlier comments and where I need to keep looking into Group Policy Editor.

    What I should really do is learn how to remotely access a Windows 7 machine for any further hands-on if and when.