Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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/');

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!