Model

Model
A Tale of Two Database Principals, part I: Introduction

I have been working on a web application which requires a database backend for the model.  The hosting provider I am using hosts SQL Server 2005 databases, so I decided to setup a database.  To my delight, the hosting provider allows to set up an optional second “read only” set of credentials. Upon setting up the database, I decided to do a little research on what these database principals can do. I’ve found that, by default, the full access principal is granted full control of the database,  an extra schema is created with the same name as the read...

posted @ Saturday, July 25, 2009 7:52 PM | Feedback (0)