Why db_owner permission is required for Repository Factory working on SQL Server 2000 at both design time and run time?

Mar 18, 2008 at 9:23 PM
I only needed readonly access the database by calling read-only stored procedures. However, I found that db_owner permission is required for Repository Factory working on SQL Server 2000 at both design time and run time, even I only read-only access database.

Is this a bug or I didn't set up anything correctly?

I used the following two test cases to confirmed that db_owner permission is required for Repository Factory working on SQL Server 2000 at both design time and run time, even I only read-only access database:

(1) Local SQL 2000 database
User is granted dbreader, dbddladmin and db_owner permissions
The unit tests passed

(2) Local SQL 2000 database
User is granted all permissions except db_owner
The unit tests failed because “Unexpected error occurred in the database”

Can anyone help to confirm this?

Thanks, Henry