I've read through the document: http://docs.farcrycms.org:8080/confluence/download/attachments/434/Users_pg_sg_permissions.pdf
And I think I get it, however the display of the pemission map in 4.0.9 does not look like it does int the document. It's not all nice and hierarchical...It's kind of clumped together paragraph style. So I've put together this basic query to help me understand the relationships between groups, policy, permissions, navnodes. SELECT dmGroup.groupId, dmGroup.groupName, dmPermissionBarnacle.PolicyGroupId, dmPolicyGroup.PolicyGroupName, dmPermission.PermissionId, dmPermission.PermissionName, dmPermissionBarnacle.Status, dmNavigation.label, dmNavigation.lNavIDAlias FROM dmPermission INNER JOIN dmPermissionBarnacle ON dmPermission.PermissionId = dmPermissionBarnacle.PermissionId INNER JOIN dmNavigation ON dmPermissionBarnacle.Reference1 = dmNavigation.ObjectID LEFT OUTER JOIN dmGroup INNER JOIN dmExternalGroupToPolicyGroup ON dmGroup.groupName = dmExternalGroupToPolicyGroup.ExternalGroupName INNER JOIN dmPolicyGroup ON dmExternalGroupToPolicyGroup.PolicyGroupId = dmPolicyGroup.PolicyGroupId ON dmPermissionBarnacle.PolicyGroupId = dmPolicyGroup.PolicyGroupId WHERE (dmPermissionBarnacle.Status <> '-1') ORDER BY dmGroup.groupId DESC, dmPermission.PermissionId Can anyone tell me if I've missed anything? Is the -1 status in the dmPermissionBarnacle table represent permissions that are not available to be given to group other than sysAdmin? I'm still working through the connections. Ultimately I will be using this info to extend the events type to include a drop down of navNodes that the user can associate the event with that is limited to the navNodes that they have access to edit content. Still a long way off but need to get there. If anyone has a better way let me know. Thanks Jaci --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
