When our custom, home-grown CMS creates data tables using the GUI, it creates them against the site-specific user schema (i.e.
sitename) instead of the
The issue is that our site-specific users currently do not "see" these other schemas even though they are in the
db_owner role. So somewhere there is a permissions setting missing which would grant them the ability to read and write against those tables.
This issue has occurred when migrating to a new SQL server. Going from 2005 Workgroup Edition to 2008 Web Edition.