Spacewalk DB Schema - View-RHNUSERMANAGEDSERVERGROUPS

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

Description Columns Query Constraints Triggers

RHNUSERMANAGEDSERVERGROUPS

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable	Comment
USER_ID	NUMBER(38)	Y	NO	NO	NO
SERVER_GROUP_ID	NUMBER(38)	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select user_id, server_group_id from rhnUserServerGroupPerms
union
select wc.id, sg.id
  from rhnServerGroup sg,
       rhnUserGroup ug,
       rhnUserGroupMembers ugm,
       web_contact wc
 where wc.org_id = sg.org_id
   and wc.id = ugm.user_id
   and ugm.user_group_id = ug.id
   and ug.group_type = (select id from rhnUserGroupType where label = 'org_admin')