Grant Permissions on Create Sprocs/UDFs

Nov 17, 2010 at 4:44 PM

I guess this is more of a feature request.

To add, sp_helprotect for each sproc and determine what permissions are added, and then add that to the end of sproc create.

This should only be done if ScriptAsCreate is true, since alter will already have the permissions set.

I'm looking into figuring it out myself, but thought I'd mention it here.

Nov 17, 2010 at 5:10 PM

-Permissions true

Already exists, just leaving the discussion in case someone else asks about it.