Need to know the tables for PPM User Groups

[ashwinipingle]

Dear PPM Experts,

I need to get list of users added to specific user groups in PPM.

Please let know the tables where the user groups, user group-members information is stored within PPM.

Best Regards,

Ashwini Pingle

[francesco_pezzoli · Accepted solution]

Dear Ashwini,

The assignment of user IDs to user groups is stored in table ACO_GROUP_USER.

Other relevant tables are ACO_GROUP (table for user groups) and ACO_GROUP_HIER (table for the user group hierarchy, relevant if you assign user groups to other user groups).

Best Regards,

Francesco

[ashwinipingle]

Thanks a lot Francesco. Exactly what I was looking for.

Best Regards,

Ashwini Pingle