I have a Coldfusion
server with a lot of websites and an MS SQL Server 2008 R2
connected with the webserver.
The issue is that all datasources are connected to SQL with the sa which is wrong.
So I tried to create a new user for each website on the SQL with permission on it's own database only. I am creating a new user but it asks also for login? Should I create a new login and a new user for each website? Also what permissions a CF website will need in the database?