Should be a very basic stuff for most.
But it took me sometime.Therefore blogging it so that I do not waste a minute in it later on
- Add the user to the server level by ensuring that in the User Mapping section ( Right click Properties ) , the default schema for the databases is dbo.
- The role membership in the User Mapping section ( Right click Properties ) should be db_owner
- Go to the respective database such as Pubs where the user has been added say user1
- Right click the properties of user1
- Ensure that the section( Schemas owned by the user ) has the db_owner checked
- Ensure that the section( Database role membership) has the db_owner checked
No comments:
Post a Comment