I may be blind here but is there a way to find out which group a user may be a member of or which folders a user has access to?
I should add it looks like someone had a script for Oracle on this older post but our Cognos store is in SQL and we do not seem to have the v_group tables/views their script mentions.
http://www.cognoise.com/index.php?topic=3482.0
Actually it looks like it was the v_group/v_user parts thatw ere giving me the issues. I was able to modify another script and get the results I needed. For group membership at least.
SELECT v_user.fullname, v_group.name, v_group_user.cmid as GROUP_ID,
v_group_user.refcmid user_id FROM cmreford1 as v_group_user
LEFT OUTER JOIN (SELECT c33.cmid user_id, UPPER (c33.NAME) ldap_id,c33.NAME fullname, c1.givenname first_name,c1.email email
FROM cmobjprops1 c1 left outer join cmobjprops33 c33
on c33.cmid = c1.cmid
UNION
SELECT cmobjprops1.cmid user_id, UPPER (cmobjprops33.NAME) ldap_id, cmobjprops1.surname last_name, cmobjprops1.givenname first_name, cmobjprops1.email
FROM cmobjprops1, cmobjprops33
WHERE cmobjprops1.cmid = cmobjprops33.cmid) v_user
ON v_group_user.refcmid = v_user.user_id
LEFT OUTER JOIN (SELECT cmobjnames.cmid cmid, UPPER (cmobjnames.NAME) name,
cmobjects.created created, cmobjects.modified modified, cmobjects.disabled disabled
FROM cmobjects, cmobjnames
WHERE cmobjects.classid IN (26, 54)
AND cmobjnames.mapdlocaleid = 24
AND cmobjects.cmid = cmobjnames.cmid) v_group
ON v_group.cmid = v_group_user.cmid
order by 2