Question: In my database, it appears two users belonging to the same teams, have access to a different amount of records.
I think there may be an issue with the Team Membership.
following users have problems:
a.PARENTSECCODEID, c.SECCODEDESC ParentTeam, a.childseccodeid, d.SECCODEDESC
ChildTeam, b.accessid, e.USERNAME, t.ACCESSID from SECCODEJOINS a left join
SECRIGHTS b on a.CHILDSECCODEID=b.SECCODEID
join (select accessid, seccodeid from secrights ) t on
a.PARENTSECCODEID=t.SECCODEID and b.ACCESSID=t.ACCESSID
join SECCODE c on a.PARENTSECCODEID=c.SECCODEID
join SECCODE d on a.CHILDSECCODEID=d.SECCODEID
join USERINFO e on b.ACCESSID=e.USERID
a.PARENTSECCODEID<>a.CHILDSECCODEID and t.ACCESSID is null
believe the issue is that if you manage teams in the SalesLogix version 8.0 web client Administration
area, it is not correctly utilizing the nested team relationship to correctly
populate the SECRIGHTS table.
the LAN administrator, when you add a team as a member of another team it adds
all users in that “child” team to the “parent” team.
If you then add a new user to the “child” team it correctly updates
the “parent” team definition to include the user added to the
The web client administration area is not doing
this. If you add a user to a team that is a child team to a parent team,
the parent team is not getting the user added to the access rights of that