Hello, I’m working with ASP.NET 2.0 and SQL Server 2005 and I’ve got some questions about security best practices. First I’ll describe the solution architecture. The ASP.NET application has 3 tiers; one of them is the Data layer, which is the only layer that communicates with the SQL Server. The application...

Hi, You may create a role and map all that users to newly created role and then assign proper permission to that particular role or in another word create a windows group on your AD and map/add all those user to windows group (who needs to access your database) and then grant then access to your sql...