#GPPT What’s New: Publish scripts to users with the new Executer windows

One request that I have heard a number of times is for a method to expose scripts written using Runtime Execute or SQL Execute to normal users.

Because these windows are Advanced Mode features designed for administrators to use, they require SQL Server sysadmin or dbo privileges as well as application level security and the System password (if used) to access.

GP Power Tools adds the new Executer windows to allow normal users to execute scripts which have been marked as “Published to Executer Window”. There are three Executer windows, one for each of the Execute windows (Runtime Execute, SQL Execute and .Net Execute).

Runtime Executer

SQL Executer

.Net Executer

The scripts that you publish can use Helper Functions to call other scripts in other languages. For example you can use Dexterity, Visual C# or Visual Basic.Net to add some dialogs to get parameter values before calling a SQL script.

Enjoy

David

This article was originally posted on http://www.winthropdc.com/blog.