topic which table shows the user names & groups in Alfresco Archive

which table shows the user names & groups

muralie39 — Wed, 19 Jan 2011 17:20:14 GMT

Hi, which table shows the user names & groups? i am imported one group by using JavaScript & i applied coordinator permissions over there.. i went to that folder & check the managed users, the group is imported & no one from the group, not able to get the full access…. any one can h

Re: which table shows the user names & groups

mrogers — Thu, 20 Jan 2011 00:13:27 GMT

there is no separate "table" for user names and groups. They are modeled as content properties and associations like everything else in alfresco.

Re: which table shows the user names & groups

muralie39 — Thu, 20 Jan 2011 05:33:13 GMT

After spending 2 to 3 hours, i find out how to check the user names & groups

select * from ALF_CHILD_ASSOC where QNAME_LOCALNAME like 'GROUP%'

select * from ALF_AUTHORITY where authority='muralik'

can you please help me how to find the relation