For an external application to Alfresco 2.1 I need to show a list of Alfresco groups a given user belongs to. I've tried to deduce this from the data in the tables but so far I haven't been able to find the solution. I think alf_node_properties and alf_child_assoc probably hold the solution. I have looked for an ER diagram (documented) but I haven't been able to find anything.
Does anyone have a SQL statement that given a user name will return the groups he is in?
Thanks
