[rt-users] Safe to delete "CachedGroupMembers"?

[Ruslan U. Zakirov]

Tom Holub wrote:
> I have an RT instance that started out as RT2, was upgraded to RT3
> soon after its release, and is now running 3.0.10.
> 
> A system crash several months ago caused some problems for the
> database; we had to manually fix a few tables to get RT running again.
> It's now working mostly fine, except for a few niggling problems.  In
> particular, there's one user who has been disabled, and who is not
> listed in any groups or as a watcher of any queues (when I view them
> with the web interface), who still gets AdminCCs on mail sent to one
> of the queues.

You can use script that I wrote to fix tables when user doesn't belong 
to 'everyone' system group and when he is not in 'priveleged' or 
'unprivileged'.
http://lists.bestpractical.com/pipermail/rt-devel/2004-April/005710.html

> 
> My working theory is that there's a problem with the CachedGroupMembers
> table.  My question is, is it safe to clear the values in this table? 
> Will RT re-create them?  
> 

RT wouldn't recreate them. This records are created when user takes 
membership in group.