Privileges for using ArcGIS with Netezza

Privileges determine what a user is authorized to do with the data and the database. Assign privileges based on the type of work the person does within the organization.

IBM Netezza Data Warehouse Appliance is deprecated at this release.

Users connecting to IBM Netezza Data Warehouse Appliance from ArcGIS require privileges on specific Netezza system objects and the user data they need to access. 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 EXECUTE ON LIBPELIBS EXECUTE ON LIBSHAPELIBS EXECUTE ON LIBSTDCPP	Required to perform spatial queries
	EXECUTE ON FUNCTION	Required to use Netezza Spatial functions
	LIST ON <user | group>	Allows data viewers to see other users or groups
	LIST ON <table1>,<table2>,<tablen>	Allows data viewers to 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>	Allows data viewers to 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	These privileges allow data creators to create tables and feature classes in the database