CREATE ROLE role_exec_dbo
GO
GRANT EXECUTE ON SCHEMA::dbo to role_exec_dbo
GO

CREATE SCHEMA mySchema
GO
CREATE ROLE exec_role_mySchema
GO
GRANT EXECUTE ON SCHEMA::mySchema to exec_role_mySchema
GO