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?

  • clintonG (3/17/2013)


    However all I really need to do is disallow Users from deleting data while using a LightSwitch app and I will continue to read and learn how to do so

    Let me simplify...

    If the database is on the user's machine and the user has local administrator permissions, there is nothing you can do to keep that user out of the database if they want access. You can slow them down, that's all.

    If you want to restrict access, the database needs to be on a server. The bear minimum of people must be admin of that server (typically sysadmins and maybe DBAs), the users then have logins to SQL and only the rights you want to give them.

    TL;DR If you give the database to someone (put it on their machine), they can do what they like.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass