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,
DECODE(g.IS_ACTIVE,1,'ACTIVE',0,'IN ACTIVE') STATUS,
FROM CMN_SEC_ASSGND_OBJ_PERM A,
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 G.LANGUAGE_CODE = 'en'
AND O.LANGUAGE_CODE = 'en'
AND RI.language_code ='en'
and ri.group_name like 'A'