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.
| 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.| 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 |