User privileges for using ArcGIS with Netezza
As the Netezza administrator, you should create groups based on what users need to do in the database, grant privileges to the groups, and add the appropriate database users to each group.
The following are common groups of users who will connect from ArcGIS and the minimum privileges they require.
Type of user
SELECT ON _V_SYS_PRIV
Needed to determine what object privileges a user has
If you are using Netezza 7, you also need to grant the following privileges:
Perform spatial queries
EXECUTE ON FUNCTION
Use Netezza Spatial functions
LIST ON <user | group>
See other users or groups
LIST ON <table1>,<table2>,<tablen>
See specific tables in the database
If you want viewers to see all tables in a database, you can grant list on TABLE.
SELECT ON <table1>,<table2>,<tablen>
Query rows within specific tables
Data creators need all the same privileges as data viewers plus the following privileges:
Create tables and feature classes in the database