Deleting Users and Groups

Ok, this seems like a pretty straightforward thing
to ask.

How in the world do I delete users and groups after
I’ve created them? I see no option for this.

Do you Yahoo!?
Yahoo! News - Today’s headlines

The inability to delete groups was an oversight in the UI according
to Jesse. The inability to delete users is by design as it could
play havoc with the referential integrity of your database.

ttfn,
-kevin-----Original Message-----
From: Mark E. Dawson, Jr. [mailto:medawsonjr@yahoo.com]
Sent: Thursday, September 12, 2002 12:49 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Deleting Users and Groups

Ok, this seems like a pretty straightforward thing
to ask.

How in the world do I delete users and groups after
I’ve created them? I see no option for this.

Do you Yahoo!?
Yahoo! News - Today’s headlines

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

Well, I deleted the Group via delete from sql in
the database. Oh well.

— “Ferguson, Kevin” KFerguso@chi.navtech.com
wrote:

The inability to delete groups was an oversight in
the UI according
to Jesse. The inability to delete users is by
design as it could
play havoc with the referential integrity of your
database.

ttfn,
-kevin

-----Original Message-----
From: Mark E. Dawson, Jr.
[mailto:medawsonjr@yahoo.com]
Sent: Thursday, September 12, 2002 12:49 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Deleting Users and Groups

Ok, this seems like a pretty straightforward thing
to ask.

How in the world do I delete users and groups after
I’ve created them? I see no option for this.


Do you Yahoo!?
Yahoo! News - Today’s headlines
http://news.yahoo.com


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at
http://fsck.com/rtfm

Do you Yahoo!?
Yahoo! News - Today’s headlines

Mark E. Dawson, Jr. wrote:

Ok, this seems like a pretty straightforward thing
to ask.

But it is not. For referential integrity reasons, users and groups
cannot be deleted (but they can be deactivated).

How in the world do I delete users and groups after
I’ve created them? I see no option for this.

Warning: This is not recommended, and /I/ would not do it. But -
You /could/ try manipulating the mysql db manually. There are not that
many places where users are references, but they should be replaced by
references to other users at least. This is easy for folks who only
commited a fistful of requests, but for someone working on about 20% of
all tickets as owner/requestor/commenter/whatever, it would be hell…

Regards,
Harald

Harald WagenerAn der Alster 4220099 Hamburg*http://www.fcb-wilkens.com

Ok, this seems like a pretty straightforward thing
to ask.

But it is not. For referential integrity reasons,
users and groups
cannot be deleted (but they can be deactivated).

That’s what constraints are for, like ‘on delete
cascade’ or triggers. I guess not the RT guys have
decided that not too many people would want that,
and so didn’t place it in the product.

Thanks for your response.

Do you Yahoo!?
Yahoo! News - Today’s headlines

“MED” == Mark E Dawson, medawsonjr@yahoo.com writes:

MED> That’s what constraints are for, like ‘on delete
MED> cascade’ or triggers. I guess not the RT guys have
MED> decided that not too many people would want that,
MED> and so didn’t place it in the product.

And that assumes your “database” has RI constraints. MySQL does
not. Postgres does, but that’s not the primary development db for RT.

MED> That’s what constraints are for, like ‘on
delete
MED> cascade’ or triggers. I guess not the RT guys
have
MED> decided that not too many people would want
that,
MED> and so didn’t place it in the product.

And that assumes your “database” has RI constraints.
MySQL does
not. Postgres does, but that’s not the primary
development db for RT.

No. MySQL does have RI constraints – more spec-
ifically, it contains the foreign key constraints
with ‘on delete cascade’ that I mentioned.

However, as I stated above, the developers may have
decided that this was a function that most people
wouldn’t need, and so left it out. But it still
could be done.

Do you Yahoo!?
Yahoo! News - Today’s headlines

MySQL does have RI constraints – more specifically, it contains the
foreign key constraints with ‘on delete cascade’ that I mentioned.

However, as I stated above, the developers may have decided that this
was a function that most people wouldn’t need, and so left it out.
But it still could be done.

The question is not only of who would find it useful, but who could be
harmed by this. Suppose all your deletions cascade, then removing a
user would remove all tickets that that user had ever been a watcher on
or sent any comments or correspondence to.

The harm in deleting a user without meaning to (or thinking that you
meant to but not properly understanding the consequences would be
great). The ‘harm’ in merely having to disable users without being able
to delete them is much smaller, and therefore a considerably safer
course of action.

Smylers
GBdirect

“MED” == Mark E Dawson, medawsonjr@yahoo.com writes:

MED> No. MySQL does have RI constraints – more spec-
MED> ifically, it contains the foreign key constraints
MED> with ‘on delete cascade’ that I mentioned.

Really? Since which version? This is great news!

“MED” == Mark E Dawson, medawsonjr@yahoo.com
writes:

MED> No. MySQL does have RI constraints – more
spec-
MED> ifically, it contains the foreign key
constraints
MED> with ‘on delete cascade’ that I mentioned.

Really? Since which version? This is great news!

Ever since MySQL 3.23.43. The latest production
version available now is 3.23.52, to put things in
perspective about how long this has been available.

Do you Yahoo!?
Yahoo! News - Today’s headlines