overheads per requests
Farshid, March 27, 2021 - 4:45 am UTC
that's right, but in large systems that not work well, because it doubles requests count, and every time I should check user roles then set context variables.
I've another problem with ORDS, Why there is just one proxy user(ords_public_user) and we can't define other proxy users( as users to call API service and use in their application) to login?
March 31, 2021 - 4:34 am UTC
because it doubles requests count,
Not sure what you mean by this. We make an extra trip between ORDS and the database, but not an extra trip to the client.
We're running ORDS to support hundreds of thousands of users using our global COVID applications, so I'm pretty confident it scales well.
RAS
Farshid, March 31, 2021 - 6:13 am UTC
Thank you for clear it. I have several questions, If you reply to them, I'm grateful.
1- How to audit Auth2 clients?
2- You replied how to use VPD, now I also want to know how to use RAS in ORDS?
3- How to use application users created in RAS for login like Auth2 clients?
4- How is refresh Token in Ords?
VPD and Pre-hook on the cloud / autonomous
Nikk, February 28, 2024 - 2:13 pm UTC
Hi All,
Is the "pre-hook" approach available in case ORDS is running as part of an autonomous DB on the cloud? I would suppose there is no access to "settings.xml" (if it exists at all) and I can find no specific reference for this configuration in the documentation.
So if one would like something like different ORDS client ids to resolve to different VPD "cases" on the cloud for an ORDS service with pure-sql (i.e. no PL/SQL) handler, what could be done?
February 29, 2024 - 3:03 am UTC
I will check with the Autonomous team but my suspicion would be that you'd nee to stand up your own ORDS on a VM to do this.
If I hear back differently, I'll update the post.