which table shows the user names & groups

[muralie39]

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 help to solve this problem…

[mrogers]

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

[muralie39]

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