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.
Users connecting to Netezza 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|
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:
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 creators need all the same privileges as data viewers plus the following privileges:
These privileges allow data creators to create tables and feature classes in the database