Controlling Permissions for Events
By default, it is possible for all users to perform all events. However, you might want to restrict who can perform certain events. Permissions can be added to your workflow transitions to make sure only designated roles can execute them. For example, in an expense reporting application, you might want only users assigned to the Manager role to be able to set an expense report to Approved.
To restrict user permissions for specific events
In the Solution Explorer, open the Workflow Processes folder.
Double-click the workflow process for which you want to set permissions. The workflow diagram is displayed on the design surface.
In the workflow diagram, select the transition for which you want to set permissions.
Open the View menu, and click Property Pages.
Select the Permissions tab, and specify the roles that have permissions for the event.
To remove permissions from a transition, clear the check box next to the role.
Click OK.
See Also
Understanding the Workflow Process for SQL Server | Adding Workflow Processes to Databases | Designing Workflow Processes for SQL Server | Initiating Workflow for a Record | Testing Workflow Processes for SQL Server | Creating Database Roles