<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Nast,<br>
<br>
When a User is created, there are a bunch of tables that are
affected (Principals, Groups, GroupMembers, ACL, Transactions, etc.).
If you just delete a record from the User table, then everything gets
out of sync. For example, the history on a ticket will show an error
because the history of a ticket uses transaction records that are
referring to the UserId you just blew away. Not Good! Like Ruslan said,
use Shredder. These tools are developed to keep all that RT stuff in
the background in sync.<br>
<br>
<br>
Kenn<br>
LBNL<br>
<br>
On 5/6/2009 5:27 PM, Ruslan Zakirov wrote:
<blockquote
cite="mid:589c94400905061727n301a3ef5x66cdcce722881ec5@mail.gmail.com"
type="cite">
<pre wrap="">shredder
On Thu, May 7, 2009 at 4:10 AM, nast linux <a class="moz-txt-link-rfc2396E" href="mailto:nastlinux@gmail.com"><nastlinux@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Dear All,
I just do disable user, but I can not delete user.
How to delete user database?
Should I delete directly through mysql?
Thanks,
ns
_______________________________________________
<a class="moz-txt-link-freetext" href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a>
Community help: <a class="moz-txt-link-freetext" href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a>
Commercial support: <a class="moz-txt-link-abbreviated" href="mailto:sales@bestpractical.com">sales@bestpractical.com</a>
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at <a class="moz-txt-link-freetext" href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a>
</pre>
</blockquote>
<pre wrap=""><!---->
</pre>
</blockquote>
</body>
</html>