• applebusch@lemmy.world
    link
    fedilink
    arrow-up
    16
    arrow-down
    1
    ·
    1 year ago

    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
      link
      fedilink
      arrow-up
      9
      ·
      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

    • lazyslacker
      link
      fedilink
      arrow-up
      3
      ·
      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.