[Rt-devel] MAJOR BUG in group membership.

Ruslan U. Zakirov cubic at acronis.ru
Thu Apr 22 15:02:09 EDT 2004


We have 449 user who has no member ship in group Everyone!

select count(1) from Principals pr left join GroupMembers gm on 
(gm.MemberId = pr.id and gm.GroupId = 3) where pr.PrincipalType = 'User' 
and gm.id is null;

Most of this users were created via CLI.

We have
select count(1) from Principals where PrincipalType = 'User';
+----------+
| count(1) |
+----------+
|    43696 |
+----------+
users.

Users by system groups
select g.id, g.Domain, g.Type, count(gm.id) members from GroupMembers 
gm, Groups g where gm.GroupId in(3,4,5) and g.id = gm.GroupId group by 
gm.GroupId;
+----+----------------+--------------+---------+
| id | Domain         | Type         | members |
+----+----------------+--------------+---------+
|  3 | SystemInternal | Everyone     |   43247 |
|  4 | SystemInternal | Privileged   |      51 |
|  5 | SystemInternal | Unprivileged |   43196 |
+----+----------------+--------------+---------+

This 449 users don't have membership in system groups.

Please, I need solution tomorrow.

					Best regards. Ruslan.



More information about the Rt-devel mailing list