'Oracle apex not recognizing user roles
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.
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:
Shared Components>Security> Authorization Scheme
- Go to or Click your
Administation Rights, underAuthorization Scheme, you need to make sure you are usingIs in Role or GroupIF 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
Shared Components>Security>Application Access Control
- Check under Role Assignments if your username is there.
- Click Administrator under Roles, and make sure
Administration Rightsunder 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 |


