Privileges Required for the Command-Line Interface - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem

Permissions required with source_user using the command-line interface are listed in the following table:

Permissions source_user Requires
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.

Permissions required with target_user using the command-line interface are listed in the following table:

Permissions target_user Requires
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.

Permissions required with staging database using an existing target table or target database are listed in the following table:

Permissions Staging Database Requires on Existing Target Tables or Target Database
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.