Permissions
The user specified in the endpoint settings must be granted access to the Netezza Performance Server (NPS) account as well as the privileges listed below.
Database privileges
- LIST on <database> to <Replicate user>
- SELECT on <database> to <Replicate user>
Table privileges
- CREATE TABLE to <Replicate user>
- LIST on TABLE to <Replicate user>
Schema privileges
- CREATE SCHEMA to <Replicate user>
- LIST on SCHEMA to <Replicate user>
View privileges
- SELECT on _T_DATABASE to <Replicate user>
- SELECT on _V_SCHEMA to <Replicate user>
- SELECT on _V_USER to <Replicate user>
- SELECT on _V_TABLE to <Replicate user>
- SELECT on _V_TABLE_DIST to <Replicate user>
- SELECT on _V_RELATION_KEYDATA to <Replicate user>
- LIST on _T_DATABASE to <Replicate user>
- LIST on _V_SCHEMA to <Replicate user>
- LIST on _V_USER to <Replicate user>
- LIST on _V_TABLE to <Replicate user>
- LIST on _V_TABLE_DIST to <Replicate user>
- LIST on _V_RELATION_KEYDATA to <Replicate user>