SQL-Server - Grant user DBO permission on database
User principals must exist in a database before you can grant them permissions.

use Restored_Prod
GO

CREATE USER [chris] FROM LOGIN [chris];
exec sp_addrolemember 'db_owner', 'chris';
GO


http://technet.microsoft.com/en-us/library/ms173463.aspx