select rt.refresh_template_name,rt.owner,rt.refresh_group_name,
rt.template_comment, nvl(rt.public_template,'N'),
u.username
from system.repcat$_refresh_templates rt,
all_users u,
system.repcat$_user_authorizations ra,
system.repcat$_template_types tt
where u.user_id = ra.user_id
and ra.refresh_template_id = rt.refresh_template_id
and tt.template_type_id = rt.template_type_id
and bitand(rawtohex(tt.flags),1) = 1
SELECT RT.REFRESH_TEMPLATE_NAME
, RT.OWNER
, RT.REFRESH_GROUP_NAME
,
RT.TEMPLATE_COMMENT
, NVL(RT.PUBLIC_TEMPLATE
, 'N')
,
U.USERNAME
FROM SYSTEM.REPCAT$_REFRESH_TEMPLATES RT
,
ALL_USERS U
,
SYSTEM.REPCAT$_USER_AUTHORIZATIONS RA
,
SYSTEM.REPCAT$_TEMPLATE_TYPES TT
WHERE U.USER_ID = RA.USER_ID
AND RA.REFRESH_TEMPLATE_ID = RT.REFRESH_TEMPLATE_ID
AND TT.TEMPLATE_TYPE_ID = RT.TEMPLATE_TYPE_ID
AND BITAND(RAWTOHEX(TT.FLAGS)
, 1) = 1
|
|
|