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. |
| 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 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. |