Groups Wizard (DB2 LUW)

Go Up to [[IBM DB2 for Linux, Unix, and Windows Object Wizards{{#if:||{{{2}}}}}]]

The Group wizard lets you define new groups and to assign the appropriate object and system level privileges. Any user who is a part of the group you create inherits the authorities and privileges assigned to the group.

To Open the Group wizard

1. On the Navigator/Explorer, find the datasource where you want to add the new group.
2. Expand the Security branch, right-click Groups, and then select New.

The following table describes the fields you may encounter as you complete the Group wizard:

Required Information	Description
What is the name of the group?	Lets you enter the name of the group.
What database authority(ies) do you want to give this group?	Select all or some of the authorities: BINDADD. User can create new database packages. CONNECT. Gives users access to the database. CREATETAB. A user can create new tables in the database. CREATE_NOT_FENCED. Allows a user to create user-defined functions. IMPLICIT_SCHEMA. Enables any user to implicitly create a schema by creating an object with a CREATE statement using a schema name that doesn't already exist. DBADM. Gives users administrative privileges. LOAD. Users can load data into a table. Note: The authorities listed here are the system privileges.