| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|---|---|---|---|---|---|
| ORG_ID | NUMBER(38) | N | NO | NO | NO | |
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| GROUP_ID | NUMBER(38) | N | NO | NO | NO | |
| GROUP_NAME | VARCHAR2(64) | N | NO | NO | NO | |
| GROUP_TYPE | VARCHAR2(64) | N | NO | NO | NO |
Legend: comment string keyword reserved word operator
SELECT UG.org_id, UGM.user_id, UG.id, UG.name, UGT.label FROM rhnUserGroupType UGT, rhnUserGroup UG, rhnUserGroupMembers UGM WHERE UG.id = UGM.user_group_id(+) AND UG.group_type = UGT.id