Hi,
I have semi-solved the problem. First the permissions problem is unrelated to the groups problem. The permission problem is traced backed to the tester using another add user interface. What I have told her to do was to user /acs-admin/users but she uses the /[sub site]/admin/users/new.tcl. This means the relationship already made when the tester adds the user and the page /admin/users/new.tcl works.
Regarding the /admin/groups page it seems that the first "[subsite name] parties" is not showing because in the view application_group_element_map.element_id does not contain the object_id of the first subsite. This is the current query :
select g.group_id, g.group_name from (
select distinct g.group_id, g.group_name
from (select group_id, group_name
from groups g, acs_objects o
where g.group_id = o.object_id
and o.object_type = 'application_group') g,
(select object_id
from all_object_party_privilege_map
where party_id = '2426' and privilege = 'read') perm,
application_group_element_map m
where perm.object_id = g.group_id
and m.package_id = '2394'
and m.element_id = g.group_id
order by g.group_id, g.group_name) g
order by lower(g.group_name)
changing the query by removing "and m.element_id = g.group_id"
select g.group_id, g.group_name from (
select distinct g.group_id, g.group_name
from (select group_id, group_name
from groups g, acs_objects o
where g.group_id = o.object_id
and o.object_type = 'application_group') g,
(select object_id
from all_object_party_privilege_map
where party_id = '2426' and privilege = 'read') perm,
application_group_element_map m
where perm.object_id = g.group_id
and m.package_id = '2394'
order by g.group_id, g.group_name) g
order by lower(g.group_name)
Gives you all of the sub site parties but of course this is not the right behavior but the original query may not be right too. It should display all the sub site parties under the main site including the first subsite. If somebody can confirm or deny this problem please do. I will gladly enter it on the SDM and maybe after I finish this site I can check further on this.
