At the moment, I am utilizing Vertica in the enterprise mode. And I am copying data from S3 source (MinIO) into Vertica columnar tables.
Per instructions available at, https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/SpecifyingCOPYFROMOptions.htm under the section 'Loading from an S3 Bucket', we should create a 'User' Storage Location for S3 bucket so that users without superuser privileges are able to copy data off of the bucket objects.
At the moment, I do not have a need for external tables (based on S3) or writing any data to S3 from Vertica. And I am running Vertica strictly in an enterprise mode. I want to be able to use a non superuser to invoke copy commands against any bucket from an S3 source such as MinIO. Is there any way to secure access to all S3 locations for users without superuser privileges globally in Vertica rather than doing this on a bucket by bucket basis?
Sandeep.