The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
That's what I've said before: We should be able to move posts between forums ourselves!
Anything that is unrelated to elephants is irrelephant Anonymous - The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944 - I'd just like a chance to prove that money can't make me happy. Me, all the time
We used to have a table (SQL) to store forum members - active or inactive...
Now we added the ability to define a group of members (mostly on role base) with a single line...
The next step was to declare a view that expands those lines with group on them to be back to the one-line-one-member situation...
Why in the elephanting elephant the view has a filter for active members only!!!
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
So for us British, European, maybe even US folks at least, we have something called the Data Protection Act, which ultimately means we "should" be careful with other peoples data and not retain it longer than we need. The thing is, as a software developer, do we know who is responsible for the data contained within the database driven apps we release?
I would say it's whoever owns the app?
What about building apps in-house? The Chief Exec?
Each organisation is obliged to appoint a DP officer who is responsible for policing the systems and procedures in use. But ultimately if there is any breach of the law the organisation as a whole tends to be held responsible. For corporate bodies that means the directors/management, and for charitable bodies it is the trustees.