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

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.20
Published
November 2021
Language
English (United States)
Last Update
2021-11-04
dita:mapPath
wph1512683331242.ditamap
dita:ditavalPath
4101_UG_dm_1620.ditaval
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

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 by ARC to gather AMP information.

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:

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 by ARC to gather AMP information.

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.