Delete User and the integrity of the database - General Support

BugNET Forums

Forum Support General Support Delete User and the integrity of the database

7/17/2008 4:48 PM

	ravensjk
13 posts

Delete User and the integrity of the database

When deleting a user the following warning is displayed:

It is higly recommended that you unauthorize the users account instead of deleting to maintain the integrity of the BugNET database. Unauthorizing the account will keep the user information intact but will not allow the user to log into the application. You can re-authorize the account at anytime if necessary from the user details page

I'm a bit neurotic and hate keeping accounts I know are not going to be used. What is the reason for this message? Is it only applicable if they have created issues? Is it a problem to the extent that if all roles were removed and no comments were made, files uploaded, issues created, etc that the user shouldn't be deleted?

Thanks,

Jason

7/17/2008 8:12 PM

	admin
645 posts
bugnetproject.com

Re: Delete User and the integrity of the database

ravensjk wrote

When deleting a user the following warning is displayed:

It is higly recommended that you unauthorize the users account instead of deleting to maintain the integrity of the BugNET database. Unauthorizing the account will keep the user information intact but will not allow the user to log into the application. You can re-authorize the account at anytime if necessary from the user details page

I'm a bit neurotic and hate keeping accounts I know are not going to be used. What is the reason for this message? Is it only applicable if they have created issues? Is it a problem to the extent that if all roles were removed and no comments were made, files uploaded, issues created, etc that the user shouldn't be deleted?

Thanks,

Jason

I believe the biggest reason for the message is that it will delete any data associated with that user, so any issues that the user is assigned, comments, attachments etc that the user created.

Davin Dubeau
BugNET - Core Developer

7/18/2008 12:22 AM

	ravensjk
13 posts

Re: Delete User and the integrity of the database

Thanks for the quick reply. That is what I was hoping you would say. I was taking the warning of database integrity literally, as in deleting a user may leave orphaned issues, etc and the app may bomb when encountering them. Cascading deletes can come in handy...

Thanks again,
Jason

7/18/2008 6:40 AM

	smoss
112 posts
www.orbitsolutions.co.za

Re: Delete User and the integrity of the database

I had the same issue with deleting users.

I created the following SQL script to reassign calls from an old user to a new user.

http://www.bugnetproject.com/Forums/tabid/54/forumid/9/threadid/1541/scope/posts/Default.aspx

I created a new user called OLDSTAFF and i moved all the issues and assignments and history from the old staff members over to the user OLDSTAFF.

7/18/2008 2:09 PM

	ravensjk
13 posts

Re: Delete User and the integrity of the database

Thanks for the link! Hey Davin, doesn't smoss deserve at least one little colored red square next to his name? :) enjoy the weekend.

Page 1 of 2

Forum

Support

General Support

Delete User and the integrity of the database

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.