(Geek) SQL table auditing.

[rasilon_x]

I've seen many weird and wacky ways of creating an audit trail in databases, some better than others. The basic requirements are that users are able to do their jobs, but aren't allowed to do anything they aren't supposed to. And that what they do is logged usefully, securely, and automatically.

Whilst this one would need tidying up for a live

Comments

[dantesvendetta]

SQL is the work of the devil...

if ($yourehappyAndYouKnowIt) {
clapyourhands;
}

See! Said I'd add you!

Mags
x

[rasilon_x]

:-)

Added you back...

[misswyoming]

Hi, you seem interesting. I added you if that's alright:)

[rasilon_x]

That's fine by me. I've added you too -- my journal is only friends only(ish) for historical reasons.

I must admit to a bit of cognitive dissonance about being called interesting on one of my most geeky posts!

Have fun :-)