topic SQL for user groups in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/sql-for-user-groups/m-p/145991#M101976 <HTML><HEAD></HEAD><BODY><SPAN>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.&nbsp; I have looked for an ER diagram (documented) but I haven't been able to find anything.</SPAN><BR /><BR /><SPAN>Does anyone have a SQL statement that given a user name will return the groups he is in? </SPAN><BR /><BR /><SPAN>Thanks</SPAN></BODY></HTML> Fri, 23 Nov 2007 14:44:00 GMT konsultex 2007-11-23T14:44:00Z SQL for user groups https://connect.hyland.com/t5/alfresco-archive/sql-for-user-groups/m-p/145991#M101976 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.&nbsp; I have Fri, 23 Nov 2007 14:44:00 GMT https://connect.hyland.com/t5/alfresco-archive/sql-for-user-groups/m-p/145991#M101976 konsultex 2007-11-23T14:44:00Z Re: SQL for user groups https://connect.hyland.com/t5/alfresco-archive/sql-for-user-groups/m-p/145992#M101977 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>The authority service should be used to find this information.</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Tue, 04 Dec 2007 14:55:54 GMT https://connect.hyland.com/t5/alfresco-archive/sql-for-user-groups/m-p/145992#M101977 andy 2007-12-04T14:55:54Z