Skip To Content

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 userRequired privilegesPurpose

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