Permissions required with source_user using the command-line interface 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. |
Permissions required with target_user using the command-line interface 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. |
Permissions required with staging database 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. |