Security requirements

You must provide Vertica account access to the Qlik Replicate user. The Replicate user must also have the following privileges in the Vertica database:

• CREATE TABLE Privileges:

  • CREATE privilege on schema

• DROP TABLE Privileges:

  • USAGE privilege on the schema that contains the table or schema owner

• TRUNCATE Privileges (If the task is configured to truncate existing tables):

  • USAGE privilege on the schema that contains the table or schema owner

• ALTER TABLE (ADD/DROP/ RENAME/ALTER-TYPE COLUMN) Privileges:

  • USAGE privilege on the schema that contains the table or schema owner

• INSERT Privileges:

  • INSERT privilege on table
  • USAGE privilege on the schema that contains the table

• UPDATE Privileges:

  • UPDATE privilege on table
  • USAGE privilege on the schema that contains the table
  • SELECT privilege on the table when executing an UPDATE statement that references table column values in a WHERE or SET clause

• DELETE Privileges:

  • DELETE privilege on table
  • USAGE privilege on schema that contains the table
  • SELECT privilege on the table when executing a DELETE statement that references table column values in a WHERE or SET clause