This content has been marked as final. Show 2 replies
Create a process pl/sql process "on load - before region" and write:
wwv_flow_api.set_security_group_id(p_security_group_id => apex_util.find_security_group_id(p_workspace => 'SCHEMA_NAME'));
apex_application.g_flow_owner := 'OWNER_NAME';
SHEMA_NAME = Name of the user schema
OWNER_NAME = Name of the owner which you want to set
Thank you for your help. I tried your method but unfortunately it doesn't work. The application still uses it's primary schema for the On Demand process.
Also, I already have two processes (On Load Before Header, On Submit) with code:
These two processes work nicely for page rendering and processing, but not for On Demand processes.
apex_application.g_flow_owner := 'SCHEMA_NAME';
Any other idea would be greatly appreciated.