how to remove dbo role requirement for .net membership in SQL database?

Mike90014

New Member
I am transitioning an application from Dev to QA. I have created an sql file to populate the database in the QA environment. In the QA environment I am using windows authentication on the db. My user has minimal permissions. I am comin up with the error\[code\]EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'QADB', schema 'dbo'.\[/code\]when I try an log in. I noticed my db creation script has:\[code\]"CREATE ROLE [aspnet_Membership_BasicAccess] AUTHORIZATION [dbo]"\[/code\]When I change the permissions of my user to dbo, the problem goes away.I do not wish for my user to be dbo. Does anybody know what I can do to remedy this?
 
Back
Top