SP execute permissions

From: Alastair Waddell (aliwaddell@wairc.wa.gov.au)
Date: 06/13/02 

From: "Alastair Waddell" <aliwaddell@wairc.wa.gov.au>
Date: Thu, 13 Jun 2002 01:02:05 -0700

Is there a way to give all users with a role (Public,
DBWriter, custom) execute permission an all SP's, without
having to go through them 1 by 1, and not making the a DBO?

I was thinking of looping through the sysobject table
where objectProperty(id, 'IsProcedure') = 1
but that would not include new SP's created.

Quantcast