User Role MSSQL Tutorial

USE YourDatabaseName
GO
ALTER USER Joe
WITH DEFAULT_SCHEMA = Production