Online Documentation for SQL Manager for DB2

Groups

A Group is a logical organization of users that have IDs according to activity or resource access authority.

Creating Groups

To create a new group:

• select the Database | New Object... main menu item;
• select Group in the Create New Object dialog;
• edit group properties using the appropriate tabs of Group Editor.

Hint: To create a new group, you can also right-click the Groups node of the DB Explorer tree and select the New Group... context menu item.

Editing Groups

To edit an existing group:

• select the group for editing in the DB Explorer tree (type the first letters of the group name for quick search);
• right-click the object and select the Edit Group <group_name>... context menu item, or simply double-click the group;
• edit group definition using the appropriate tabs of Group Editor.

Dropping Groups

To drop a group:

• select the group to drop in the DB Explorer tree;
• right-click the object and select the Drop Group <group_name>... context menu item;
• confirm dropping in the dialog window.

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new group;

Ctrl+O to edit the selected group;

Shift+Del to drop the object from the database.