We have seen similar requirements many times. How do i find all the sites a particular user is a member of? One way is to write a SQL query with joins on the alf_ tables in the database. But Alfresco advises against hitting the data base directly. Instead we can use webscripts that are provided by Alfresco to get the information we need quickly.
Sometimes, the default site permissions would not be enough for particular use case. Take for example, a user is added as a collaborator to a site. The user can add documents, but cannot delete any. Now say we want to add delete permission for this user. How do we go about doing that quickly?
This time we want to prevent users who are not defined as admins or in the admin group from creating their own sites. Is there a quick and simple way make this change and persist this across amp deployments?