Creating database groups

To create a database group, log in to the Netezza Performance Server database by using an account that has Create Group administrative privilege. The following are some example commands:

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

SYSTEM.ADMIN(ADMIN)=> CREATE GROUP qa WITH USER dlee;
CREATE GROUP

SYSTEM.ADMIN(ADMIN)=> CREATE GROUP execs WITH MAXPRIORITY CRITICAL;
CREATE GROUP

The CREATE GROUP command also includes options that you can use to specify timeout options, rowset limits (the maximum number of rows a query can return), account expiration, and priority for the sessions and queries of the group members. The resulting group is owned by the user who created the group.

Remember: Session settings such as timeouts, priority, expiration, and rowset limits, can be set on a per-user, per-group, and system-wide level. The Netezza Performance Server system checks the settings for a user first to find the values to use; if not set for the user, the system uses the group settings (the most restrictive of the settings for all of the groups to which the user belongs); if not set for any group, the system uses the system-wide settings.