APEX Instant Tips #41 How to secure a RESTful API with ORDS and OAuth2

[@kevinzhang8974]

a super great tip. I am always puzzled for ORDS security and so far haven't used it in production application. It is time for me to give it a try. Thank you Insum and Plamen! Kevin, another APEX developer from Chicagoland.

[@Superdooperhero]

Thanks! This is super helpful!

[@Superdooperhero]

Now if you can show how to access Google Cloud Vision API OCR via REST as well, that would be awesome!

[@Insum]

Right?? I always hate how the cheese drips down the side.

[@Superdooperhero]

@@Insum For extra cheese you can add how to REST to Power BI while using ORDS pagination.

[@chadlomax4500]

I would love to see how to use Azure B2C or Okta to really secure this api. I need to know what user is running the query from my client app so that I only query the database for their records.

[@kartikjadeja1254]

While accesing Rest Api in Oracle APEX, for every new REST service we need to add a SSL certificate into Oracle Wallet, can we automate this ?

[@joelkusgan5266]

Nice video. Can you provide a simple example where 2 different ords communicate via oath2 or basic authentication? For example, ords A can access ords B data via oath2 or basic authentication restful api?

[@susanadonaximatusruiz5594]

I got lost at the access token url in the POSTman, which htttps address should be that ??

[@Insum]

Hi Susana, have you checked out Plamen's blogs listed in the video description? He goes into greater detail there.

[@susanadonaximatusruiz5594]

@@Insum I will do it now! thank you so much