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
)