Required Privileges | Teradata Data Mover - 17.10 - Required Privileges - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.10
Release Date
June 2021
Content Type
User Guide
Publication ID
B035-4101-061K
Language
English (United States)

Required source_user permissions are listed in the following table:

Permission Description
SELECT Required to select data from source table.
DUMP Required to archive data from source table.
MONITOR Required to collect TVI asset information (such as, site id, cluster id, and product type).
CREATE TABLE Required to create source staging tables.
DROP TABLE Required to drop source staging tables.
INSERT Required to insert data into source staging tables.
Required target_user permissions are listed in the following table:
Additional grants may be required when performing a full database copy and object types exist in the source database that are not covered by the GRANT statements below.
Permission Description
CREATE TABLE Required to create staging, target, error, log, and work tables.
DROP TABLE Required to drop staging, target error, log, and work tables.
CREATE MACRO Required by Teradata PT API Stream operator to create macro.
DROP MACRO Required by Teradata PT API Stream operator to drop macro.
EXECUTE MACRO Required by Teradata PT API Stream operator to run macro.
INSERT Required to insert data into staging, target, error, log, and work tables.
SELECT Required to select data from staging table.
RESTORE Required to restore data to target table.
MONITOR Required to collect TVI asset information (such as, site id, cluster id, and product type).
DELETE Required to delete data from the target table.

Required staging database permissions using an existing target table or target database are listed in the following table:

Permission Description
SELECT WITH GRANT OPTION Required to select data from source table.
INSERT WITH GRANT OPTION Required to insert data into target table.
UPDATE WITH GRANT OPTION Required to update data in target table.
DELETE WITH GRANT OPTION Required to delete data from target table.
Required DSA permissions on the SYSBAR database for source and target users are listed in the following table:
Permission Description
  • DROP TABLE
  • CREATE TABLE
  • SELECT
  • UPDATE
  • DELETE
  • EXECUTE PROCEDURE
  • CREATE MACRO
  • DROP MACRO
Required for DSMAIN system configuration.