RHNUSERCHANNEL
DDL scriptColumns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
| ORG_ID | NUMBER(38) | Y | NO | NO | NO | |
| CHANNEL_ID | NUMBER(38) | Y | NO | NO | NO | |
| ROLE | VARCHAR2(9) | Y | NO | NO | NO | |
Query:
Legend: string keyword reserved word operator
select cfp.user_id user_id,
cfp.org_id org_id,
cfm.channel_id channel_id,
'manage' role
from rhnChannelFamilyMembers cfm,
rhnUserChannelFamilyPerms cfp
where cfp.channel_family_id = cfm.channel_family_id
and rhn_channel.user_role_check(cfm.channel_id,
cfp.user_id, 'manage') = 1
union all
select cfp.user_id user_id,
cfp.org_id org_id,
cfm.channel_id channel_id,
'subscribe' role
from rhnChannelFamilyMembers cfm,
rhnUserChannelFamilyPerms cfp
where cfp.channel_family_id = cfm.channel_family_id
and rhn_channel.user_role_check(cfm.channel_id,
cfp.user_id, 'subscribe') = 1