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

Teradata® Data Mover User Guide - 20.01
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Data Mover
Release Number
20.01
Published
November 2023
Language
English (United States)
Last Update
2023-12-05
dita:mapPath
hlv1700545853003.ditamap
dita:ditavalPath
mpm1591127278842.ditaval
dita:id
don1467241476387
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 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.
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.