One of the primary reasons that VFP developers make the decision to move their data to SQL Server is the promise of additional security.  However, if you don’t take the time to set things up properly, you data can be just as vulnerable as if it were in VFP tables.  This article will give an overview of the different SQL Server security models, then cover one of the best (in my opinion) ways to secure your data: the application role.