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 below.
| 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 |
|---|---|
|
Required for DSMAIN system configuration. |