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.
Comment on I'll just be a quick 3h
applebusch@lemmy.world 1 year agoAt 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?
lazyslacker@sh.itjust.works 1 year ago
pomodoro_longbreak@sh.itjust.works 1 year ago
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 1 year ago
phpmysqladmin 😆