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

Accepted answer


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

Howdy, Stranger!

Log In

To view full details, sign in.


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