ORA-20401: Authorization failed for URI using dbms_cloud access to object storage
Summary:
Getting authorization failed error connecting to the object storage from oci base 23 ai db.
ORA-20401: Authorization failed for URI - https://objectstorage.us-chicago-1.oraclecloud.com/n/namespace/b/bucket/ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 2060ORA-06512: at "C##CLOUD$SERVICE.DBMS_CLOUD", line 12660ORA-06512: at line 1
Content (please ensure you mask any confidential information):
I have a base db in my OCI tenancy created in my compartment. I have an object storage bucket in the same compartment. Group and users are created in the domain in the same compartment. API key has been generated and added. User is added to a group that has policy defined to read buckets, read objects, manage objects, manage object-family in the compartment. Dynamic group is created to read database-tools-family and secret bundle. Connection has been created for a db user referencing the ocid, private key etc of the oci user. Private end point selected to access database via