Edit D:\app\Administrator\product\11.2.0\dbhome

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\demo\wfuignt.sql

REM $Header: wfuignt.sql 26.4 2004/05/14 08:29:44 appldev ship $
REM +======================================================================+
REM | Copyright (c) 1998 Oracle Corporation Redwood Shores, California, USA|
REM |                       All rights reserved.                           |
REM +======================================================================+
REM
REM NAME
REM     wfuignt.sql  -  Grant access on workflow UI to wf_plsql_ui
grant execute on wfa_html to wf_plsql_ui;
grant execute on wf_route to wf_plsql_ui;
grant execute on wf_monitor to wf_plsql_ui;
grant execute on wf_pref to wf_plsql_ui;
grant execute on fnd_document_management to wf_plsql_ui;
grant execute on wf_item_definition to wf_plsql_ui;
grant execute on wf_initiate to wf_plsql_ui;
grant execute on wf_demo to wf_plsql_ui;
grant execute on wf_reqdemo to wf_plsql_ui;
REM grant execute on wf_surveydemo to wf_plsql_ui;
grant execute on wf_activities_vl_pub to wf_plsql_ui;
grant execute on wf_lov to wf_plsql_ui;
grant execute on wf_core to wf_plsql_ui;
grant execute on wf_event_html to wf_plsql_ui;
grant execute on wf_setup to wf_plsql_ui;
grant execute on wf_eventdemo to wf_plsql_ui;

drop public synonym wfa_html;
drop public synonym wf_route;
drop public synonym wf_monitor;
drop public synonym wf_pref;
drop public synonym fnd_document_management;
drop public synonym wf_item_definition;
drop public synonym wf_initiate;
drop public synonym wf_demo;
drop public synonym wf_reqdemo;
REM drop public synonym wf_surveydemo;
drop public synonym wf_activities_vl_pub;
drop public synonym wf_lov;
drop public synonym wf_core;
drop public synonym wf_event_html;
drop public synonym wf_setup;
drop public synonym wf_eventdemo;

create public synonym wfa_html for wfa_html;
create public synonym wf_route for wf_route;
create public synonym wf_monitor for wf_monitor;
create public synonym wf_pref for wf_pref;
create public synonym fnd_document_management for fnd_document_management;
create public synonym wf_item_definition for wf_item_definition;
create public synonym wf_initiate for wf_initiate;
create public synonym wf_demo for wf_demo;
create public synonym wf_reqdemo for wf_reqdemo;
REM create public synonym wf_surveydemo for wf_surveydemo;
create public synonym wf_activities_vl_pub for wf_activities_vl_pub;
create public synonym wf_lov for wf_lov;
create public synonym wf_core for wf_core;
create public synonym wf_event_html for wf_event_html;
create public synonym wf_setup for wf_setup;
create public synonym wf_eventdemo for wf_eventdemo;

REM assign the wf_plsql_ui role to owf_mgr
grant wf_plsql_ui to &1;

REM now 
exit;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de