Looking up user access?

[atomicfox]

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?

[atomicfox]

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

[atomicfox]

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