this post was submitted on 29 Nov 2023
1217 points (99.2% liked)

Programmer Humor

19817 readers
610 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] applebusch@lemmy.world 15 points 1 year ago (2 children)

At that point you teach them how to do it themselves. Isn't there a way to give them an account that only has read access so they can't inadvertently screw up the database?

[–] pomodoro_longbreak@sh.itjust.works 9 points 1 year ago (1 children)

I like that idea, and it actually did work for our Marketing guy (Salesforce has a kind of SQL). Near the end there, I just had to debug a few of his harder errors, or double check a script that was going to be running on production.

Never thought of it for Postres or Mysql, etc, but I suppose there's got to be an easy enough way to get someone access

[–] 4am@lemm.ee 6 points 1 year ago

phpmysqladmin 😆

[–] lazyslacker@sh.itjust.works 3 points 1 year ago

In Oracle you'd just set up a user that has limited access and give them those credentials. Creating a few views that pulls in the data they want is a bonus.