I created a login in sql server 2005, then I tried to create the user in the database of by using this login.
Then without a clear concept of schema, in the window of creating users, in the top part, default schema, I chose dbo, schema owned by this user I choose the datareader, and database role membership I chose database reader and writer.
1.I don't even know this is right or not, I only want the user to be able to read the database and write to the database.
2. Also since I want to change another login name as well as the user name, I tried to delete the user, it doesn't allow me to, give the errro: the user cannot be dropped for he is the owner of a schema.
How can I drop the user?