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.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
