Spacewalk DB Schema - View-RHNUSERSERVERPERMSDUPES

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

RHNUSERSERVERPERMSDUPES

DDL script

Columns

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

Query:

Legend: comment string keyword reserved word operator

select	usg.user_id,
	sgm.server_id
from	rhnServerGroupMembers sgm,
	rhnUserServerGroupPerms usg
where	usg.server_group_id = sgm.server_group_id
union all
select	ugm.user_id, s.id
from	rhnServer s,
	rhnUserGroup ug,
	rhnUserGroupMembers ugm,
	rhnUserGroupType ugt
where	ugt.label = 'org_admin'
	and ugm.user_group_id = ug.id
	and ug.group_type = ugt.id
	and ug.org_id = s.org_id