AnsweredAssumed Answered

SQL for user groups

Question asked by konsultex on Nov 23, 2007
Latest reply on Dec 4, 2007 by andy
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

Outcomes