Hi Team,
I want to find the instances on which instance rights are given in the group.
Ex. Suppose there is a group "A" having "Portlet - View" rights on "Unfilled Requirement portlet". so I would like to find on which portlets the instance level right is granted in this group.
like this if there are other instance rights like "Page - View", "Process - Start" in group "A". That I would like to find.
From below query i can find the names of rights like "Portlet - View", "Page - View", "Process - Start" but not on which instances these rights are given. Can anyone help me?
SELECT DISTINCT ri.group_name Access_Group,
G.GROUP_NAME Access_Right,
'Instance' OBS_Name,
DECODE(g.IS_ACTIVE,1,'ACTIVE',0,'IN ACTIVE') STATUS,
g.is_active act_flag,
ri.group_code,
ri.id ri_id
--null obsid
--3 fltr_type
FROM CMN_SEC_ASSGND_OBJ_PERM A,
CMN_SEC_GROUPS_V G,
ODF_OBJECTS_V O,
CMN_SEC_USER_GROUPS UG,
CMN_SEC_GROUPS_V RI,
WHERE A.PRINCIPAL_ID =UG.GROUP_ID
AND A.PRINCIPAL_TYPE = 'GROUP'
AND A.RIGHT_ID = G.ID
AND G.RIGHT_TYPE = O.RIGHT_CODE
AND RI.ID = UG.GROUP_ID
AND a.object_instance_id=cap.pk_id
AND G.LANGUAGE_CODE = 'en'
AND O.LANGUAGE_CODE = 'en'
AND RI.language_code ='en'
and ri.group_name like 'A'