I am trying to get an application working with RAS. I have set up all the requirements, but when I enable RAS in the authentication scheme then the RAS session is for the user XSGUEST, not for the logged-in user, hence no access to any table or procedure is possible and the post-login event fails.
When I create the user session in a script from SQLDev then the session is created for that user and all authorization (including policies on a table) works.
Any clues? I found that case sensitivity of user and role names sometimes causes issues in RAS, but I do not see what can be wrong in my case here. I created the roles in APEX under “shared components→Application Access Control” with the same case as the RAS roles, and assigned a database role that gives full access to all schema objects of the parsing schema to both RAS roles. What I see is that the “static identifier” of these Apex roles is in uppercase, which makes it confusing: what is used in the background, upper or lower case?