Use the following steps to grant an existing database user db_owner permissions Theses steps assume that you are connected to SQL Database in Object Explorer in SSMS and are connected to your SQL ...

In the below i ran this against StackOverflow2010 from Brant Ozar, It will not only script all permissions but generate the correct SQL Statement so you can recreate them if needed. This allows for ...