Hi,
I have created a user in my Workspace using de Apex Administration tool. Then I created a Role within my application. This Role I assigned to a Authentication Scheme with type 'Is in Role or Group'. This authorization scheme I joined to a page of my application.
Finally I created a User Role Assignments with the user and role created before.
The results is not working, when I login with this user I don't see the page with the authorization scheme joined.
When I run following script, it returns 'user is Not an administrator:
declare
l\_is\_admin boolean := false;
begin
l\_is\_admin := APEX\_ACL.HAS\_USER\_ROLE (
p\_application\_id => 100,
p\_user\_name => 'INFLLID',
p\_role\_static\_id => 'ADMINISTRATION' );
if not l\_is\_admin then
raise\_application\_error(-20001, 'user is NOT an administrator' );
end if;
end;
The role is not found, but as you can see on the screenshot above, I have created the assignments.
Is there somewhere a difference between a workspace user account and a application account, as now I see there is only a join on 'username', 'INFJHOS' is a workspace account and I used the same name 'INFJHOS' to create the user role assignment.
Can someone help me with this?
Thanks a lot in advance.
Kind regards,
Johan Hoste