Spacewalk DB Schema - View-RHNUSERGROUPMEMBERSHIP

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNUSERGROUPMEMBERSHIP

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
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

Query:

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