RHNCHANNELPERMISSIONS
DDL scriptColumns
Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
---|
ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
CHANNEL_ID | NUMBER(38) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select distinct org_id, channel_id
from ( select privcf.org_id,
cfm.channel_id
from rhnChannelFamilyMembers cfm,
rhnPrivateChannelFamily privcf
where privcf.channel_family_id = cfm.channel_family_id
union all
select u.org_id, cfm.channel_id
from web_contact u,
rhnChannelFamilyMembers cfm,
rhnPublicChannelFamily pubcf
where pubcf.channel_family_id = cfm.channel_family_id
) S