.

Wednesday, January 31, 2018

Workaround to assign workflow administrator privileges

When you try to create a business event using NON Sysadmin user, you may not find "create" button.


As the "Workflow System Administrator" assigned to "Workflow Administrator" role.


It also mentioned that "Set the value to ' * ' to grant administrative privileges to all users"


Since you do not have sysadmin role. You can not update.


The work around is as below


select text from wf_resources --save the value
 where name='WF_ADMIN_ROLE'
and text<>'*';


update wf_resources set text='*'
 where name='WF_ADMIN_ROLE'
and text<>'*';


Once you are done.


update back with old value