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	Required privileges	Purpose
Data viewer	SELECT ON _V_SYS_PRIV	Needed to determine what object privileges a user has
	SELECT ON SPATIAL_REF_SYS SELECT ON GEOMETRY_COLUMNS EXECUTE ON LIBGEOSLIBS EXECUTE ON LIBSTDCPP EXECUTE ON LIBSPATIALUTILS If you are using Netezza 7, you also need to grant the following privileges: EXECUTE ON LIBPELIBS EXECUTE ON LIBSHAPELIBS EXECUTE ON LIBSTDCPP	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 creator	Data creators need all the same privileges as data viewers plus the following privileges: CREATE TABLE INSERT ON SPATIAL_REF_SYS INSERT, UPDATE, DELETE ON GEOMETRY_COLUMNS	Create tables and feature classes in the database