Last post Mar 29, 2012 10:38 AM by cloucas
Feb 28, 2012 08:06 AM|cloucas|LINK
I am wondering what the best approach is in handling users who leave the organisaton and who must be then de-activated from an ASP.Net application. I have developed an ASP.Net app that helps managers assign tasks to users, and then allows users to re-assign
the task, or add comments, etc. Clearly, deleting a user, will create problems in the application in many places as for example a task screen with a drop down showing all the users is automatically selected to the project manager's username; if we delete the
user, then the application fails.
Feb 28, 2012 08:24 AM|shashankgwl|LINK
Where are you getting your users from? e.g. if you are getting them from active directory, then probably you need to mark your users as
Deleted=true in some periodically running service. e.g. nightly running service querying the AD and updating the database
Feb 29, 2012 12:00 AM|cloucas|LINK
Mar 05, 2012 10:04 AM|RagMan85|LINK
Is there a way in this provider to mark a bit column for a user as "deleted"?
Mar 14, 2012 04:42 AM|cloucas|LINK
There is an "Active" field in the database to show that a user is active. You are saying that I shold probably use that instead of physically deleting the user?
Mar 14, 2012 11:05 AM|RagMan85|LINK
That's exactly how we handle "deletions" in most cases. You can always clean up the database later, say, once a month, by removing all "inactive" users.
Mar 15, 2012 12:06 PM|atconway|LINK
Marking them as "Inactive" sounds like the best approach for your situation. In fact, if you have any referential integrity in the database, physically deleting the user will either 1) throw errors or 2) remove
all traces of anything that employee ever did (cascading delete). Typically problem #2 from my last sentence is not desired because an applications 'history' then becomes incomplete. If you mark them as 'Inactive' then through selective processing,
you can decide where that user's information still needs to remain active (maybe in reporting of sorts) and where it should not be displayed or used.
Mar 29, 2012 10:38 AM|cloucas|LINK
Your recommendation is very valid and that's exactly the course of action I will follow. Thanks a lot!