The Many Ways To Configure SQL Database Security for DNN.
Posted by: Shaun Walker,
on 09 May 2007 |
View original | Bookmarked: 0 time(s)
DNN has many ways to configure the SQL database based on the security that is needed. To make it easier to evaluate which security model to use, I have listed the possible scenerios and how to setup each scenerio.
Scenerio #1 (dbowner access, dbo)
You can keep the databaseOwner in the web.config file set to dbo and set the permissions for the user you are going to access the site with to only have db_owner permissions. This assumes that the default schema for the user that is used in the connectionString...