'Oracle apex not recognizing user roles

enter image description here

So I have the users in a table and I know my login system works because I use it for other workspaces. However across all the applications in this particular workspace I am having an error where users roles are not being recognized in particular I can't even get the admin page to work for me and I am a developer. If anyone has any clue on how to fix this it would be greatly appreciated.

enter image description here



Solution 1:[1]

If that first image is the default Admin pages, then wouldn't that mean you have access since you can see that page? (which by default, if you let APEX create it for you through New Page > Features > Access Control) has Administration Rights set as the Authorization scheme

You have two places to check to find the issue:

  1. Shared Components > Security > Authorization Scheme
  • Go to or Click your Administation Rights, under Authorization Scheme, you need to make sure you are using Is in Role or Group IF that is the requirement and you are to use the created roles. Make sure the role, Administrator (if default roles exist) is listed.
  • if validation is once per session, and you're still in the same session. log out and log back in. The problem should go away
  1. Shared Components > Security > Application Access Control
  • Check under Role Assignments if your username is there.
  • Click Administrator under Roles, and make sure Administration Rights under Associated Authorization Schemes has the Is in Role or Group as the scheme type

If there is a different Authorization scheme (not Is in Role or Group) or you have different roles, then I would suggest post a new question with more details on your setup.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Norman Aberin