[rt-users] How to delete users?

Stephen Turner sturner at MIT.EDU
Tue May 9 09:13:42 EDT 2006


At Monday 5/8/2006 05:34 PM, Tomasz Wlodek wrote:
>Hi,
>
>Due to some testing I had to create several fake users in RT. Those users
>were never added to any group, ever posted anything, never created any
>ticket. Now I need to delete them.
>
>The manual says that you cannot delete users, only disable them. Well, I
>do not believe that I cannot do what I want. I want to delete them in
>order not to pollute databases with junk.
>
>I want to go to rt database, go to table Users and execute mysql delete
>command on those users. This will delete them. But is it enough? Is the
>user information cross referenced somehow from other tables?
>
>Those users did not do any activity, so they do not own any tickets, and
>the like. I assume that they do not appear in any tables but Users, but I
>would like to be sure.

Tomasz,

Don't do it!!!! You'll be sorry.

Grab Ruslan's RTx::Shredder extension - it removes tickets & users 
safely. See http://wiki.bestpractical.com/index.cgi?Contributions 
under Packages.

Steve





More information about the rt-users mailing list