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.
| Object Action | DB2 LUW | ORCL | SYB ASE | SYB IQ |
|---|---|---|---|---|
|
✓ |
✓ | |||
|
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
||
|
✓ |
✓ |
✓ |