Hi ,
I'am a Newbie on APEX and have a problem with the apex dictionary views apex_workspaces and apex_applications.
I want to change the status of a application to available/unavailable via script as a non apex user and as a non sys or system user during maintenance work. My idea was to select the workspace id from apex_workspaces and all applications assigned to this workspace id from apex_applications. Then I want to set the application status with wwv_flow_api.set_flow_status like the following code
---
declare
PRAGMA AUTONOMOUS_TRANSACTION;
begin
wwv_flow_api.set_security_group_id(p_security_group_id=><workspace id>);
wwv_flow_api.set_flow_status (p_flow_id=><application id>,p_flow_status=>'UNAVAILABLE');
commit;
end;
---
I have granted execute privilege on wwv_flow_api and select privileges on apex_applications and apex_workspaces to my script user. But I can't see any data. When I connect to the database as a apex workspace schema via sql*plus I can only see the data for workspaces which are assigned with this database schema and data for applications are included in this workspace. It seems to me, that there is a security mechanism like virtual privat database.
Is there a possibility to select data from apex_workspaces and apex_applications as a non sys, system or apex workspace schema? What kind of privileges will be needed?
Thanks and Regards
Sigrid