On 2017-11-01 15:54, Kurt Wendt wrote:
Interesting discussion - considering a situation here at my job just today/yesterday.
An email from a manager claiming that since this one employee is no longer with the co. (although the email was late since the guy left about 4 weeks ago) - was asking to have this User removed from these various systems. So - I responded yesterday that I had deleted the user record from this one system.
Then - this buddy of mine, another programmer here - he was out yesterday, so he asks me about the deletion of the record. He was worried that the deletion of the record would cause problems if there are FK constraints! I told him he need not worry - since for the most part in the system I did it - there really are mostly no FK's in there. Of course, I know there are a couple - but, nothing that would be impacted by the removal of a user from a table.
So - yes - I can relate.
-K-
I always advise to disable or deactivate and remove access rather than delete completely.