--Resource Instance Rights
SELECT DISTINCT a.right_id, g.right_type, g.description description, o.name right_type_name,
g.group_name right_name, g.group_code, g.is_automatic
FROM cmn_sec_assgnd_obj_perm a, cmn_sec_groups_v g, odf_objects_v o
WHERE a.principal_id = 5000108 --resource internal ID
AND a.principal_type = 'USER'
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
ORDER BY right_name