Sql Server 2008 - Removing Schema Ownership
I just created a new web application that accepts some form based input from the user and inserts it in into the database. To go along with this I created a new user in the databas
Solution 1:
I had same issue today and found a way to remove user as owner of schema. Open Schema node below Security in database and change the owner for the user that you mistakenly used with the default owner. For example if some oddball user name is listed as schema owner for db_datareader, change it to db_reader and so on.
Solution 2:
No, you shouldn't have assigned ownership of the schema to the user. You should have just made the user a member of the schema. Revert ownership to dbo and check that the user account is not still a member of the schema.
Post a Comment for "Sql Server 2008 - Removing Schema Ownership"