AnsweredAssumed Answered

Query to find OBS path of OBS unit rights for resources

Question asked by nityananda on Nov 18, 2016
Every resource have specific Global rights, Instance rights and OBS unit rights.
I am looking to write a query that specifies which resource have OBS unit rights and that OBS unit rights belongs to which OBS path. I have written up to the resources having OBS unit rights(Above letter in Italic) but still unsucessfull to find that OBS unit rights belongs to which OBS path(Above letter in bold).
SELECT CMNU.USER_NAME "USER_NAME",
CMNU.FULL_NAME "FULL_NAME",
'OBS' "RIGHTS_TYPE",
g.group_name "GROUP_NAME"
FROM NIKU.cmn_sec_groups_v g,
NIKU.cmn_sec_assgnd_right ar,
(select rownum,
cmn.id,
cmn.USER_NAME,
cmn.FIRST_NAME||' '||CMN.LAST_NAME "FULL_NAME"
from NIKU.cmn_sec_users cmn
where rownum <= 1000) CMNU
WHERE AR.principal_id = cmnu.id
AND g.language_code = 'en'
AND ar.right_id = g.id
AND (g.is_automatic != 1 OR g.is_automatic IS NULL)
AND g.right_type IS NOT NULL
AND g.is_active = 1
ORDER BY USER_NAME asc;
Any ideas or help would be appreciated.
Thanks
Nityananda#

Outcomes