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:
- SELECT privileges on the source table
- USAGE privilege on source table schema
- INSERT privileges for the destination table in target database
- USAGE privilege on destination table schema
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.