I have a list of existing stored proceudures that I can get by running the below query. I have a new sqluser called "XXXXXX" . How can I iterate through the result set in sql and give execute permissions to user XXXXXX. Any help or direction would be most appreciated.
SELECT [name] FROM sys.objects obj WHERE obj.[type] = 'P' and name like'JL_%'