Controlling Permissions for Events
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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