AnsweredAssumed Answered

How to find instance rights of group.

Question asked by Sandeep_p on Apr 10, 2015
Latest reply on Apr 10, 2015 by Dave

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'

Outcomes