I am using SQL server 2008 R2. Now there's only 20 employees that access customers' database. We are developping a web application that will be put on a DMZ for customers to access their accounts and make some updates to it or even make Orders.
My question is regarding the account of the customers. Where shall i put the accounts? there's about 10,000 customers. Shall i create a table contains Username and passwords of the customers, and i manage the security access on the application level based
on which group the customer related to?
Or let the script creates the customer account and put it in "SQL Server Auhentication" ie. under security / logins.
Thanks in advance,
View Complete Post