Tuesday, January 31, 2012

script to grant execute to a user

SELECT 'grant execute on ' + name + ' to blahuser' AS function_name FROM sys.objectsWHERE type_desc LIKE '%FUNCTION%' or type_desc LIKE '%STORED_PROCEDURE%' ;

No comments:

Post a Comment