Thursday, 28 October 2010

How to reset Workflow Administrator in 11i

Recently one of my development instance having issue coz of change the Workflow Administrator privilege to user.

Finally managed with this solution,

1. To change the workflow administrator role, the System Administrator:Any security group responsibility must be assigned to yourself. Try to assign this responsibility to your user in order to change the workflow administrator.
If you cannot assign it to you for some reason, you will need to update it from sqlplus.

update wf_resources
set text = 'SYSADMIN'
where name = 'WF_ADMIN_ROLE';

This action will assign your workflow administrator role to your SYSADMIN user.  After updating it, if you want to change it, please do it via the workflow configuration page using the SYSADMIN user.

2. Retest the issue.

3. Migrate the solution as appropriate to other environments.

SocialTwist Tell-a-Friend

Related Posts by Categories

No comments: