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 7 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 4 points 1 year ago

phpmysqladmin 😆

[–] lazyslacker@sh.itjust.works 2 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.