So the deeper I get into my first Windows Forms application the more I'm questioning myself. In the VB6 days I would distribute my apps with a password protected MS Access db (not very secure) and hope nobody hacked into it.
In this app. I created my MDF in MS SQL 2008, copied the mdf and ldf to my VS 2008 application directory and set up a datasource connection to it. When I view the db in VS 2008 I see all of my tables, views and sproc's but I do not see a security node or users. So does my mdf get distributed with no security? Can anyone just attach it to their local MSSQL version and open the db? If it is in fact wide open, can it be locked down or do I need a different solution?