Client Request:
I've lost my Admin/Survey Editor credentials, How do I get them back?

Support Response:
Run the following query and it will return any user within your application that is using the Survey Editor role:

/* List all users, this query will return duplicates if a user is in multiple roles with survey edit permission */
SELECT * FROM ckbx_IdentityRoles INNER JOIN ckbx_Role ON ((ckbx_Role.RoleID) = (ckbx_IdentityRoles.RoleID)) LEFT OUTER JOIN ckbx_RolePermissions ON ((ckbx_RolePermissions.RoleID) = (ckbx_Role.RoleID)) LEFT OUTER JOIN ckbx_Permission ON ((ckbx_Permission.PermissionID) = (ckbx_RolePermissions.PermissionID)) WHERE ((ckbx_Permission.PermissionName) = ('Form.Edit') OR (ckbx_Role.RoleName) = ('System Administrator'))