Access by users in the same user groups to a survey

[ihill]

I've been having trouble setting up Checkbox to automatically grant access to a survey created by a user with the roll of a survey editor to another user with the roll of survey administrator. Both users are in the same user group.

I want to avoid having to grant permissions manually to users in the same group for surveys created by users in that same group.

I also am creating groups programmatically through an outside process and also want to grant access to those created groups, again without having to manually set access.

Ideally, we would like to do this on the Db side.

Any suggestions?

[ncushing]

To configure users, we highly recommend using the User Management web service that is part of version 4.3 of Checkbox. You can contact support to get the documentation for this web service.

Regarding granting permission to surveys, future releases will include web services to do this work, but to do all the work in the database, there are several steps to take. You'll need to create entries in the following tables:

ckbx_AccessControlEntries
ckbx_AccessControlEntry
ckbx_Policy
ckbx_PolicyPermissions

ckbx_AccessControlEntries maps individual ACL entries to an ACL. In Checkbox, the ID of the ACL for a survey can be found in the ckbx_Template table. Each ACL entry in ckbx_AccessControlEntry maps an AccessPermissible entity (which is either a user Group or a user) to a policy, which is a collection of permissions. Take a look at the entries in these tables for your survey creator, since you'll basically need to duplicate them for the extra user you want to grant administrator access to the survey to.