I have successfully set up SSO with an OAuth2 provider in Oracle APEX, and user authentication works as expected. However, when a user logs in via SSO, only their username and session are recognized in APEX.
I want to assign this SSO user to the ACL (Access Control List) in Oracle APEX. To do this, I manually created a dummy user in APEX with the same username as the SSO user and assigned the necessary roles, including admin privileges. While this allows the user to access restricted pages, it does not grant full CRUD (Create, Read, Update, Delete) privileges within the ACL.
When attempting to insert the user into the ACL, an error message appears stating that the user needs admin privileges. This suggests that even though the user has been assigned the admin role manually, it is not being recognized properly for ACL operations.