IF  EXISTS (SELECT * FROM sys.database_principals WHERE name = N'Developer' AND type = 'R')
    DROP ROLE [Developer]
GO
-- Create the database role
CREATE ROLE [Developer] AUTHORIZATION [db_owner]
GO
-- Grant database level permissions to the role
GRANT ALTER ANY SCHEMA TO [Developer]
GO
GRANT CREATE FUNCTION TO [Developer]
GO
GRANT CREATE PROCEDURE TO [Developer]
GO
GRANT SHOWPLAN TO [Developer]
GO
GRANT VIEW DEFINITION TO [Developer]
GO
GRANT EXECUTE TO [Developer] WITH GRANT OPTION 
GO

USE [dba_objects_TEST]
GO
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[usp_dba_testing]') AND type in (N'P', N'PC'))
    DROP PROCEDURE [dbo].[usp_dba_testing]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[usp_dba_testing]
AS
BEGIN
	SET NOCOUNT ON;

    SELECT TOP 20 *
      FROM dbo.DeadlockEvents;
END
GO
GRANT EXECUTE ON [dbo].[usp_dba_testing] TO [public];
GO

GRANT EXECUTE... WITH GRANT OPTION