IBM PureData® System for Analytics (Netezza) and Db2 privilege compatibility

Many Netezza® privileges have similar or equivalent Db2® privileges. In some cases, a Netezza privilege maps to a Db2 authority.

Object privileges

Use the following table to map Netezza object privileges to Db2 privileges or authorities.

For sequences, only the ALTER and USAGE privileges apply.

Table 1. Object privileges
Netezza privilege Db2 mapping
ABORT WLMADM authority (required if you want to cancel an activity by using the WLM_CANCEL_ACTIVITY procedure)
ALTER ALTER privilege; also, ALTERIN privilege (applies only to schemas)
DELETE DELETE privilege
DROP DROPIN privilege (applies only to schemas)
EXECUTE EXECUTE privilege (applies only to functions and procedures)
EXECUTE AS No equivalent available
GENSTATS CONTROL privilege (for a particular table)

SQLADM authority (for all tables in the database)
GROOM CONTROL privilege (for a particular table)

SQLADM authority (for all tables in the database)
INSERT INSERT privilege
LABEL ACCESS SECADM authority
LABEL EXPAND SECADM authority
LABEL RESTRICT SECADM authority
LIST No equivalent available
LOAD INSERT privilege
SELECT SELECT privilege
TRUNCATE DELETE privilege
UPDATE UPDATE privilege

Administration privileges

Use the following table to map Netezza administration privileges to Db2 privileges or authorities.
Table 2. Administration privileges
Netezza privilege Db2 mapping
BACKUP No equivalent available
CREATE AGGREGATE CREATE_EXTERNAL_ROUTINE authority
CREATE DATABASE CREATE SCHEMA authority or DBADM authority, which includes CREATE SCHEMA authority (Netezza databases are mapped to Db2 schemas)
CREATE EXTERNAL TABLE CREATETAB authority
CREATE FUNCTION CREATE_EXTERNAL_ROUTINE authority
CREATE GROUP SECADM authority (required to create a role)
CREATE INDEX CONTROL privilege
CREATE LIBRARY No equivalent available
CREATE MATERIALIZED VIEW CREATETAB authority
CREATE PROCEDURE CREATEIN privilege (use to restrict creation privileges at the schema level)
CREATE SCHEDULER RULE WLMADM authority
CREATE SCHEMA DBADM authority
CREATE SEQUENCE CREATEIN (use to restrict creation privileges at the schema level)
CREATE SYNONYM CREATEIN (use to restrict creation privileges at the schema level)
CREATE TABLE CREATETAB authority
CREATE TEMP TABLE CREATETAB authority
CREATE USER No equivalent available
CREATE VIEW CREATEIN (use to restrict creation privileges at the schema level)
MANAGE HARDWARE No equivalent available
MANAGE SECURITY SECADM authority
MANAGE SYSTEM DBADM authority
RESTORE No equivalent available
UNFENCE CREATE_NOT_FENCED_ROUTINE
VACUUM No equivalent available