Thursday, December 07, 2006

SQL Server 2005 - Adding an user

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
  1. 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.
  2. The role membership in the User Mapping section ( Right click Properties ) should be db_owner
  3. Go to the respective database such as Pubs where the user has been added say user1
  4. Right click the properties of user1
  5. Ensure that the section( Schemas owned by the user ) has the db_owner checked
  6. Ensure that the section( Database role membership) has the db_owner checked

No comments:

Adda is the Bengali for discussion.Bengali is a language like English.