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.
Answer:
The
following users have problems:
select
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
left
join (select accessid, seccodeid from secrights ) t on
a.PARENTSECCODEID=t.SECCODEID and b.ACCESSID=t.ACCESSID
left
join SECCODE c on a.PARENTSECCODEID=c.SECCODEID
left
join SECCODE d on a.CHILDSECCODEID=d.SECCODEID
left
join USERINFO e on b.ACCESSID=e.USERID
where
a.PARENTSECCODEID<>a.CHILDSECCODEID and t.ACCESSID is null
I
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.
In
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
“child” team.
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
parent team.
