topic SQL query to fetch spaces on which user has permissions in Alfresco Archive

SQL query to fetch spaces on which user has permissions

nikes — Fri, 05 Apr 2013 08:12:15 GMT

Hello,I am trying to list all the spaces and subspaces on which users has permissions (any permission) using SQL.I have managed to list spaces/sub-spaces where a user is invited directly and also as a member of a group.but what I am trying also is when user is not directly invited on a space by by a

Re: SQL query to fetch spaces on which user has permissions

jpfi — Fri, 05 Apr 2013 09:29:18 GMT

Hi,
why are you using SQL instead of any Alfresco API as recommended?
Cheers, Jan

Re: SQL query to fetch spaces on which user has permissions

nikes — Fri, 05 Apr 2013 09:46:30 GMT

Hi,

Yes, we always use API for any sorts of communication with Alfresco.

Actually we have urgent request, so to save time and opportunity to dig in Alfresco schema.

Additional question:
Does Alfresco evaluates permission at runtime? I mean when a Parent group is invited, and user is added in a subgroup.
Or full permissions hierarchy (Subgroups at any level) is persisted in ACL related tables?

Thanks,
Nikesh