How to read OCI bucket files in OCI Oracle Database SQL using OCI resource principals
How to read Oracle Cloud object storage bucket files using SQL in an OCI Oracle database using OCI resource principals While these steps can be used for autonomous and non-autonomous Oracle Databases, we require for this guide that the database be in Oracle Cloud to make use of OCI's Resource Principal permissions. First, we create a dynamic group--e.g., named "ADB-dgrp" containing the database matching rule: resource.id = 'ocid1.autonomousdatabase.iad..aaaxxxxxx' In OCI, grant the appropriate…