Netezza CREATE GROUP Command

  • Post author:
  • Post last modified:February 27, 2018
  • Post category:Netezza
  • Reading time:3 mins read

A group with one or more members is a user group. User groups are used to simplify access management. In this article, we will discuss about the Netezza Create Group command.

Netezza CREATE GROUP Command

Each and every member of the user group inherits its privileges and other settings. For e.g. you may want to create the user groups called Developers, Admins etc. Each user group will be provided with set of privileges that each members inherits upon adding to it.

Netezza CREATE GROUP command Syntax

CREATE GROUP name [WITH <clause> [<clause>…] ]

Below are some imports clause options:

SYSID <groupid> |
DEFPRIORITY {CRITICAL|HIGH|NORMAL|LOW|NONE} |
MAXPRIORITY {CRITICAL|HIGH|NORMAL|LOW|NONE} |
ROWSETLIMIT <rslimit> |
SESSIONTIMEOUT <sessiontimeout> |
QUERYTIMEOUT <querytimeout> |
CONCURRENT SESSIONS <concsessions> |
RESOURCE MINIMUM <min_percent> |
RESOURCE MAXIMUM <max_percent> |
JOB MAXIMUM <jobmax> |
COLLECT HISTORY {ON|OFF|DEFAULT} |
ALLOW CROSS JOIN {TRUE|FALSE|NULL} |
PASSWORDEXPIRY <days>
ACCESS TIME {ALL|DEFAULT|(<access_time>[,<access_time>…])} |
USER <user>[,<user>…]

Where access_time is DAY { ALL | <day>[,<day>…] } [ START <time> END <time> ] for details on other options read my other posts Netezza Create user command and examples and Netezza alter user command and examples.

Netezza CREATE GROUP Command Examples

Create Netezza User Group

SYSTEM.ADMIN(ADMIN)=> CREATE GROUP developer;
CREATE GROUP

Add user to the User Group

TRAINING.ADMIN(ADMIN)=> ALTER GROUP developer ADD USER testuser1, testuser2;
ALTER GROUP

Alter User Group to add the Password Expiry days

TRAINING.ADMIN(ADMIN)=> ALTER GROUP developer PASSWORDEXPIRY 45;
ALTER GROUP
SYSTEM.ADMIN(ADMIN)=>

Read:

Tags: