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 18, 2013 at 8:22 am

    #1598058

    GilaMonster (3/17/2013)

    clintonG (3/17/2013)

    The SQLExpress database will be intsalled on a share of a Windows7 machine

    Errrr....

    SQL is not Access. It's not a file-based database that sits on a share. It's a service that other machines connect to.

    With the SQL Service running on a Windows 7 machine, anyone who has administrative access to that Windows 7 machine can do what they like to your database (and that includes dropping it, uninstalling the service, etc).

    You need to lock that machine down and treat it like a server if it's serving data.

    I understand thank you. However doesn't Group Policy Editor remain accessible to any Windows 7 Administrator anyway?

    So with your insights and those of others I've worked through creating a login, user, flexible role with DENY DELETE and the app does not allow deleting data when it is being used which is all I wanted to learn get done at the moment.