Groups

Go Up to Supported Objects

Groups are a defined collection of database users. The primary use of groups is to consolidate the management of permissions. By matching together similar users into groups, you can greatly reduce the number of commands required to set permissions.

Every user automatically belongs to the public group. To assign a user to another group, add the user to that group. Then the user belongs to that group and public.

Note: A user can only belong to one group at a time other than public.

Creating and editing

• Groups Wizard (DB2 LUW) and Groups Editor (IBM DB2 LUW)
• Groups Editor (Oracle)

• Groups Wizard (Sybase ASE) and Groups Editor (Sybase ASE)

Note: Creation and editing of objects of this type is not supported against Sybase IQ datasources.

DBMS platform availability and object actions/operations supported

The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.

	DB2 LUW	ORCL	SYB ASE	SYB IQ
Drop			✓	✓
Extract	✓	✓	✓	✓
Migrate	✓	✓	✓
Report	✓	✓	✓

DBMS platform availability and object actions/operations supported

The table below lists the platforms on which this object type is available. It also lists the object actions available against objects of this type For an introduction to object actions and details on usage of specific actions, see Object actions.