[rt-users] Shredding users

Ken Crocker kfcrocker at lbl.gov
Tue Nov 17 13:21:35 EST 2009


G.Booth,

Yep, that seems odd. I've done most of my changes to the USERS Table 
manually in the past. WAY too intense! I'm hoping to move over to 
shredder with the 3.8.6 version we're about to test.

Kenn
LBNL

On 11/17/2009 9:56 AM, G.Booth wrote:
> On Tue, 17 Nov 2009 08:30:49 -0800
>  Ken Crocker <kfcrocker at lbl.gov> wrote:
>> G.Booth,
>>
>> You could also use the SQL native to your DataBase and do it 
>> manually. However, keep in mind that it is a RISKY business. You must 
>> be sure that whatever UserID you change the info to REALLY exists, or 
>> your history will break when looking at a ticket.
>>
>> Kenn
>> LBNL
>
> Hi Kenn
>
> Im trying to avoid that if I can, for just the reasons you list.
> I can't figure out what the "replace_relations" part of the shredder 
> is for if not this. If you dump the sql as you run the shred and 
> re-inject it into the database, it seems (at first glance) to have 
> done exactly what I want and all i need to do is now delete the 
> original user. It seems very odd that it would let you go to all of 
> the trouble to rename everything only to then wipe all evidence of it.
>
> regards
> Garry
>



More information about the rt-users mailing list