dbms_cloud.list_objects not returning data as other user than ADMIN
Summary:
As ADMIN dbms_cloud.list_objects returns a list of objetcs; As other DB user with same credentials not returning data and not returning errors.
Content (please ensure you mask any confidential information):
Initial setup :
- created a storage bucket,
- created OCI user with acces to bucket : added Auth token to user
- created user_credential in autonomous DB
In Database Actions, as user ADMIN the following test is success (effective values replaced) : all objects are listed as expected
select object_name, bytes from dbms_cloud.list_objects('MY_USER_CRED','https://swiftobjectstorage.ca-toronto-1.oraclecloud.com/v1/my_namespace/bucket-mybucket/');