Storage Location Privileges

Users and roles without superuser privileges can copy data to and from storage locations as long as the following conditions are met, where a superuser:

  1. Creates a a special class of storage location (CREATE LOCATION) specifying the USAGE argument set to 'USER' , which indicates the specified area is accessible to non-superusers users.
  2. Grants users or roles READ and/or WRITE access to the specified location using the GRANT (Storage Location) statement.

    Note: GRANT/REVOKE (Storage Location) statements are applicable only to 'USER' storage locations.

Once such storage locations exist and the appropriate privileges are granted, users and roles granted READ privileges can copy data from files in the storage location into a table. Those granted WRITE privileges can export data from a table to the storage location on which they have been granted access. WRITE privileges also let users save COPY statement exceptions and rejected data files from Vertica to the specified storage location.

Only a superuser can add, alter, retire, drop, and restore a location, as well as set and measure location performance. All non-dbadmin users or roles require READ and/or WRITE permissions on the location.

Privilege Description
READ

Allows the user to copy data from files in the storage location into a table.

WRITE

Allows the user to copy data to the specific storage location. Users with WRITE privileges can also save COPY statement exceptions and rejected data files to the specified storage location.