Hi Team,
We are using APEX on Autonomous Database Serverless in OCI cloud with Private Endpoint. We have implemented OAuth2 authentication for SSO login to the application provided by OKTA.
We would like to provision some Secured REST APIs to external application to enable them to access certain entities in our APEX environment.
I have seen many documents to secure a APEX REST API, that tells us about creating Roles, Privilages and Client. Use those clients IDs and Client secrets to secure the API.
I would like to explore or know more about, how we can utilize the existing OAuth2 credentials from OKTA to secure the REST API.
How I can link a existing credential to a Role or Privilege?
How we can enable get a common Token for all the environments of APEX?
A end to end guide would be much appreciated.