Reply to: Permie morons

[Old Greg]

Jesus, we've had users with SA rights turn off triggers as they couldn't get their data into the database, with predictable results.

The problem stems from the public sector managers having their person do work for them. So you have a DBA team, and Manager in Wilmslow has Fred, a chap who has been doing stuff for him for years, who he's secured admin rights to everything for. Not a DBA, but he was fairly competent with spreadsheets.

Seen it all through my contracting crew. We even had one chap change a data field name, as he didn't like it. These people are also, unfortunately, apparently unsackable...

Not to worry, at my last project the supplier couldn't understand why it mattered that they'd forgotten to include patients' drug allergies in their data migration schema.

[quackhandle]

Jesus, we've had users with SA rights turn off triggers as they couldn't get their data into the database, with predictable results.

Seen it all through my contracting crew. We even had one chap change a data field name, as he didn't like it. These people are also, unfortunately, apparently unsackable...

qh

[jmo21]

Though I'm projects/build normally, at a recent gig I helped out on BAU, got a ticket; Cannot receive xxxxx file from mainframe, this has not worked for 15 years....

Obviously critical then....

"Closed as stupid"

[Gym beast]

Do users change data directly in the DB? Do they make schema changes?

If the answer is "No, they shouldn't", WTF are they SA users?

(sighs)
Because I may not demote them. Much as I'd like to.

[stek]

Though I'm projects/build normally, at a recent gig I helped out on BAU, got a ticket; Cannot receive xxxxx file from mainframe, this has not worked for 15 years....

Obviously critical then....

[Old Hack]

Do users change data directly in the DB? Do they make schema changes?

If the answer is "No, they shouldn't", WTF are they SA users?

Jesus, we've had users with SA rights turn off triggers as they couldn't get their data into the database, with predictable results.

The problem stems from the public sector managers having their person do work for them. So you have a DBA team, and Manager in Wilmslow has Fred, a chap who has been doing stuff for him for years, who he's secured admin rights to everything for. Not a DBA, but he was fairly competent with spreadsheets.

Seen it all through my contracting crew. We even had one chap change a data field name, as he didn't like it. These people are also, unfortunately, apparently unsackable...

[DimPrawn]

BTW - any other DBA's here a bit nervous about Joe Schmoe users lurking on your DB's with SA rights????

Do users change data directly in the DB? Do they make schema changes?

If the answer is "No, they shouldn't", WTF are they SA users?

[Gym beast]

Had one dude on the Apps team yesterday who IM'ed me,

"Hi (insertmynamehere), I'm trying to create a connection but it's not working, I've been battling with this all morning!! Here's the code and error...."

"Servername..db.name.tblname"

"Error: The connection string will only accept a maximum of 3 qualified object names"

Me (after 3 seconds, quaking with unsuppressed laughter): You've got an excess dot between your server and DB name".


THEN proceeded to badger me to change some Insert code, I told him he needs to open a ticket, he gets a8sey and says, "It's just a small change", I reply, "It's just a small ticket! Open it now and I'll have the code sorted for you by lunchtime", he goes off in a huff and says he'll get a mate to change it.

BTW - any other DBA's here a bit nervous about Joe Schmoe users lurking on your DB's with SA rights????

[original PM]

Just to add my 2 pence worth

Had one of these the other day, user was saying last 6 months data is missing from system it went into the service team who could not fathom out why as when they looked at system all data was up to date.

Eventually they come to yours truly who quickly identifed the problem was that the user was logging into the training system (which is clearly labelled training at many points whilst you log on and during useage) and yes that data was approx 6 months old ( should have also been able to tell as all data had been desenstised so all customers were called John Smith)...

many of these all round!

[sasguru]

You worked out that stats puzzle yet?

No. Why should I?

[aussielong]

A replacement for proggy. And so soon. That's CUk efficiency for you.

You worked out that stats puzzle yet?

[Old Greg]

Hey smarty pants. You got me there!

Are you a permie? Or just a c0ck sucker?

Are the two mutually exclusive? Or are you just trying to get some random guy off the Internet to suck your cock?

[sasguru]

Hey smarty pants. You got me there!

Are you a permie? Or just a c0ck sucker?

A replacement for proggy. And so soon. That's CUk efficiency for you.

[aussielong]

Why the f&@k did you think that would interest anybody?

Hey smarty pants. You got me there!

Are you a permie? Or just a c0ck sucker?

[Old Greg]

Why the f&@k did you think that would interest anybody? I mean, that level of detail to make your point!? Was it necessary. Are you showing off?

Why the f&@k did you think that would interest anybody?