0 Replies Latest reply on Apr 17, 2018 9:44 AM by Bill Sanderson

    I need a query of Users and the Group that they are in

    Bill Sanderson Active Member

      To support our user management across business units, I need to run a query of the users from DQSINFA_DOM schema that lists each user and the groups that user is a member of.  I have the information to select the users (PO_USERINFO), and think I have the Groups (PO_IDOBJ where PSI_DISCRIMINATOR = 'GROUP') but I can not find the relationship between the user and the group.

       

      What table/view will provide me with the relationship between the User and the Group?

       

      Bill S.