Hi There,
I created an application called ‘Application Control’, in this application it makes use of two API's… ‘APEX_ACL.ADD_USER_ROLE’ & ‘APEX_ACL.REMOVE_USER_ROLE’ with the following process as an example…
BEGIN
APEX_ACL.ADD_USER_ROLE (
p_application_id => :P2_APP_NAME,
p_user_name => :P2_USERNAME,
p_role_static_id => :P2_APP_ROLE -- Now mapped correctly as "CONTRIBUTOR" when "Manager" is selected
);
END;
Here we could select an application, a user and the role to grant them, for example…
App ID = 117
Username = J-SMITH
Role = ADMINISTRATOR
It works fine for applications within that works space. For example APP_PORTAL sits in a workspace called PORTAL along with a couple of others.
The issue I have is that it doesn't work on apps in a different workspace, for example we have a workspace called SALES with an app having an id of 120 in there. When I try this…
App ID = 120
Username = J-SMITH
Role = ADMINISTRATOR
It gives me this error…
Is there a way user roles can be granted to an application that exists in different workspaces?
Kind Regards,
Mat