Custom Role

USE DBName;
GO
CREATE ROLE usrDBOSchema;
GO
GRANT ALTER, DELETE, EXECUTE, INSERT, REFERENCES, SELECT, UPDATE, VIEW DEFINITION ON SCHEMA ::dbo TO usrDBOSchema;
GO
GRANT CREATE TABLE, CREATE PROCEDURE, CREATE FUNCTION, CREATE VIEW TO usrdboschema;
GO