Netezza Groups

There two types of groups in Netezza.  One type is the typical permission, privileges on specific objects in the NPS.  Another group is called Resource Sharing Group (RSG) for workload management.  You can use this group to define resource utilisation percentages from total NPS resources.

Object Permission Group

CREATE GROUP CELEBI_USR_PETL_ST_GRP;

Or, to create group and add user(s)

CREATE GROUP FIRST_GROUP WITH USER1,USER2;

or add user in group using alter

ALTER GROUP FIRST_GROUP ADD USER USER1;

or drop user from group

ALTER GROUP FIRST_GROUP DROP USER USER1;


RSG Group

CREATE GROUP EBI_ENR_USER WITH
SESSIONTIMEOUT 30
QUERYTIMEOUT 300
DEFPRIORITY NORMAL
MAXPRIORITY NORMAL
RESOURCE MINIMUM 10
RESOURCE MAXIMUM 70
MAXIMUM 30 ;