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