I have changed the owner of the views and I also created a new role and put both users in that role. Each user can change any views that...

I gave the user the db_ddladmin role and it now works. However, this also gave this user rights I do not want them to have.

Lori responded indicating...