crashwave icon

Script Grant SELECT (Execute) on All Scalar functions

crashwave | PRO | 01/28/21 12:33:12 PM UTC (Edited) | 0 ⭐ | 186 👁️ | Never ⏰ | []
text |

180 B

|

None

|

0 👍

/

0 👎

Raw Download Clone Embed Print View 
/*This generates scripts to Grant EXECUTE on all scalar function*/
select 'GRANT EXECUTE ON ' + name + ' TO %USER%'
from sys.objects
where ( type LIKE '%fn%')
AND is_ms_shipped = 0

Comments