Granting EXECUTE permissions to all stored procedures

From: DBA72 (anonymous_at_discussions.microsoft.com)
Date: 04/30/04


Date: Fri, 30 Apr 2004 01:31:03 -0700

I want to allow my user to have exec permissions on all stored procs in the database. Is there a quick way to do this? Right now, the only way I know how to do this is to go into the permissions for the user and check the EXEC checkbox for each individual stored proc...