DB is able to access the data, how another user is not able to access
Permission denied for storage location S3 location
You have to create a USER storage location.
In particular, Step #2...
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.