AnsweredAssumed Answered

Query for Instance Rights of a Group

Question asked by e_martin on Apr 22, 2013
Latest reply on Jun 11, 2014 by Pankaj_Navlekar
I have the following Query:
SELECT 
*
FROM CMN_SEC_ASSGND_OBJ_PERM A, 
CMN_SEC_GROUPS_V G, 
ODF_OBJECTS_V O 
WHERE A.PRINCIPAL_TYPE = 'GROUP' 
AND A.RIGHT_ID = G.ID 
AND G.RIGHT_TYPE = O.RIGHT_CODE 
AND G.LANGUAGE_CODE = 'en' 
AND O.LANGUAGE_CODE = 'en' 
AND G.IS_ACTIVE=1
AND A.PRINCIPAL_ID = '5104724' (Code for my Dummy Group with only 3 instance rights, 2 portlet view, 1 page view)
However the results return 7 results, am I missing a table?

The goal of this query is to be used in a portlet that will allow certain users to look up the Instance Rights that a given group has. The current query returns results, but I'm not sure what I need to join to be able to see if this query is even close to what I'm needing.

Outcomes