• What about using Application Roles?

    http://www.techrepublic.com/article/secure-sql-server-application-roles/5068954

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified