Oracle Autonomous 19c, APEX 24.1.7
I am using custom authentication. I wanted to enable RAS on my application. I tried to follow along the steps here here (following exactly the steps, works fine, but that's for APEX authentication schema. I want to implement RAS for my custom auth scheme). I also relied heavily on the steps here.
MYFIN is the schema name that has all my tables. APEX app is attached to WKSP_MYFIN schema
- Login as admin
- created db role:
db_role_user
- granted dml on table to the role
grant execute on myfin.authentication_pkg to db_role_user;grant db_role_user to myfin with admin option;EXEC XS_ADMIN_CLOUD_UTIL.GRANT_SYSTEM_PRIVILEGE('PROVISION','MYFIN');EXEC XS_ADMIN_CLOUD_UTIL.GRANT_SYSTEM_PRIVILEGE('ADMIN_ANY_SEC_POLICY','MYFIN');- login as MYFIN
exec sys.xs_principal.create_role(name => 'app_role_user', enabled => true);grant db_role_user to app_role_user;exec sys.xs_principal.create_user(name => 'XSTEST', schema => 'MYFIN');
exec sys.xs_principal.set_password('XSTEST', 'pasword');
exec sys.xs_principal.grant_roles('XSTEST', 'XSCONNECT');
exec sys.xs_principal.grant_roles('XSTEST', 'app_role_user');
I stopped here and did not create any acls (although I tried previously and got errors too).
When I try to login, I get this error: ORA-46069: operation disallowed in an application session
The details:
The highlighted PLSQL code is my login process, and it calls my custom authentication function. This works fine once I disable RAS.
Where can I start investigating this from?