I/O Privileges

Users need no special permissions to connect to and disconnect from an Vertica database.

To EXPORT TO and COPY FROM Vertica, the user must have:

To COPY FROM STDIN and use local COPY a user must have INSERT privileges on the table and USAGE privilege on schema.

Note: Only a superuser can COPY from file.