This project is read-only.

Changing orchard tables schema name from dbo to our own schema?

Topics: Core, Customizing Orchard, General, Installing Orchard
Jul 16, 2015 at 7:35 PM
Can i change orchard tables schema from dbo to our own schema name? i saw the db connection string is in settings.txt file in appdata folder. But i couldnt find any specification on schema name.
Also can i change connection string from settings.txt to web.config.
Jul 16, 2015 at 7:59 PM
You can change the schema name if you want. You can either provide the logon credentials as part of the connection string, or assign a Windows account to the IIS apppool that is associated with a SQL login, which in turn is mapped to the desired schema. Nothing to do from Orchard's perspective to make this work.

Regarding changing the connection string from being read from Settings.txt to web.config, I recommend creating a GitHub issue for that if one doesn't already exist.
Marked as answer by vinton on 7/28/2015 at 8:40 AM
Jul 17, 2015 at 9:29 PM
So to actually get this to work, you need to make sure that the database user has not privs on the dbo schema. Even if the default for that user is a different schema it will write to dbo if that user has permissions to do so.
Marked as answer by vinton on 7/28/2015 at 8:40 AM
Jul 28, 2015 at 4:40 PM
thank you