Security requirements
A user must have the following privileges granted in the Teradata Database to use a Teradata Database target in a Qlik Replicate task:
- GRANT SELECT ON <database>
- GRANT INSERT ON <database>
- GRANT DELETE ON <database>
- GRANT UPDATE ON <database>
- GRANT EXECUTE ON <database>
- GRANT EXECUTE FUNCTION ON <database>
- GRANT EXECUTE PROCEDURE ON <database>
- GRANT CREATE TABLE ON <database>
- GRANT DROP TABLE ON <database>
- GRANT CREATE VIEW ON <database>
- GRANT DROP VIEW ON <database>
- GRANT NONTEMPORAL on <database>
-
GRANT CHECKPOINT ON <database>
When the Stream TPT Operator is selected (in the Advanced tab), the following privilege is also required:
- GRANT CREATE MACRO ON <database>