Execute permission on stored procedures

Hi,

I don't like granting my signed in user dbo owner privileges - so I have written this extra SQL script. Maybe you would like to incorporate it in your next version.

In my example, my user is qe2stampsuser


GRANT DELETE, UPDATE, SELECT, INSERT
TO [Qe2StampUser]
GO

DECLARE @ProcName VARCHAR(255), @PreviousProcName VARCHAR(255)

SELECT TOP 1 @ProcName = name
    FROM sys.Procedures
    WHERE (name LIKE 'Nop_%')
    ORDER BY Name


DECLARE @WhoTo VARCHAR(100);

WHILE @ProcName IS NOT NULL
BEGIN

  EXEC('GRANT EXECUTE ON dbo.' + @ProcName + ' TO [Qe2StampUser]')

  SELECT @PreviousProcName = @ProcName, @ProcName = NULL
  
  SELECT TOP 1 @ProcName = name
    FROM sys.Procedures
    WHERE (name LIKE 'Nop_%')
      AND name > @PreviousProcName
      ORDER BY Name

END