Wednesday, May 27, 2009

How to assign ACL to a Workflow?

Here is what you do.

1) Get the r_object_id of the workflow definition

select r_object_id from dm_process where object_name = 'name of your workflow definition';

2) use update statement to update the ACL.

update dm_process object set acl_name = 'acl you created' where r_object_id = ' from earlier query';

second way:--

One way is to login to DA and update it from there. You need to find out where the process template is store though. Get the i_folder_id of the dm_process object and then r_folder_path of dm_folder.

Login to DA and go to the specified folder path. In DA change the filter to "show all object" and find the workflow definition. Go to properties and you can assign the acl from there.

If this answers your question please mark it as answered and award points.