Hi, In my application, I have a user table which to which is referenced by many other tables. Collectively they all contain information about the user. In the account settings, I want to let the user have an option to delete his account. However I want to retain the records and just prevent the user from gaining access to the app. I use email / password combination for access to the application. What'd be the best way to disable/de-activate account?
The approach that I have in my mind is to have a column called 'deleted' in the user table and mark the field as T or F depending on if user is active or has chosen to delete his account. After that, I can do 'onvalidation' stuff on login (and registration, in case user wants to re-activate account) .. Do you think its a good idea? Any other suggestions?
