Data Engineering Podcast

Managing Database Access Control For Teams With strongDM

Listen Later
Summary

Controlling access to a database is a solved problem… right? It can be straightforward for small teams and a small number of storage engines, but once either or both of those start to scale then things quickly become complex and difficult to manage. After years of running across the same issues in numerous companies and even more projects Justin McCarthy built strongDM to solve database access management for everyone. In this episode he explains how the strongDM proxy works to grant and audit access to storage systems and the benefits that it provides to engineers and team leads.

Introduction
  • Hello and welcome to the Data Engineering Podcast, the show about modern data management
  • When you’re ready to build your next pipeline, or want to test out the projects you hear about on the show, you’ll need somewhere to deploy it, so check out Linode. With 200Gbit private networking, scalable shared block storage, and a 40Gbit public network, you’ve got everything you need to run a fast, reliable, and bullet-proof data platform. If you need global distribution, they’ve got that covered too with world-wide datacenters including new ones in Toronto and Mumbai. Go to dataengineeringpodcast.com/linode today to get a $20 credit and launch a new server in under a minute.
  • Go to dataengineeringpodcast.com to subscribe to the show, sign up for the mailing list, read the show notes, and get in touch.
  • To help other people find the show please leave a review on iTunes, or Google Play Music, tell your friends and co-workers, and share it on social media.
  • Join the community in the new Zulip chat workspace at dataengineeringpodcast.com/chat
  • Your host is Tobias Macey and today I’m interviewing Justin McCarthy about StrongDM, a hosted service that simplifies access controls for your data
    • Interview
    • Introduction
    • How did you get involved in the area of data management?
    • Can you start by explaining the problem that StrongDM is solving and how the company got started?
      • What are some of the most common challenges around managing access and authentication for data storage systems?
      • What are some of the most interesting workarounds that you have seen?
      • Which areas of authentication, authorization, and auditing are most commonly overlooked or misunderstood?
      • Can you describe the architecture of your system?
        • What strategies have you used to enable interfacing with such a wide variety of storage systems?
        • What additional capabilities do you provide beyond what is natively available in the underlying systems?
        • What are some of the most difficult aspects of managing varying levels of permission for different roles across the diversity of platforms that you support, given that they each have different capabilities natively?
        • For a customer who is onboarding, what is involved in setting up your platform to integrate with their systems?
        • What are some of the assumptions that you made about your problem domain and market when you first started which have been disproven?
        • How do organizations in different industries react to your product and how do their policies around granting access to data differ?
        • What are some of the most interesting/unexpected/challenging lessons that you have learned in the process of building and growing StrongDM?
          • Contact Info
          • LinkedIn
          • @justinm on Twitter
            • Parting Question
            • From your perspective, what is the biggest gap in the tooling or technology for data management today?
              • Links
              • StrongDM
              • Authentication Vs. Authorization
              • Hashicorp Vault
              • Configuration Management
              • Chef
              • Puppet
              • SaltStack
              • Ansible
              • Okta
              • SSO (Single Sign On
              • SOC 2
              • Two Factor Authentication
              • SSH (Secure SHell)
              • RDP

                • The intro and outro music is from The Hug by The Freak Fandango Orchestra / CC BY-SA

                Support Data Engineering Podcast

                ...more
                View all episodesView all episodes
                Download on the App Store
                Data Engineering PodcastBy Tobias Macey
                • 4.5
                • 4.5
                • 4.5
                • 4.5
                • 4.5

                4.5

                142 ratings

                More shows like Data Engineering Podcast

                View all
                The Changelog: Software Development, Open Source by Changelog Media

                The Changelog: Software Development, Open Source

                289 Listeners

                Software Engineering Daily by Software Engineering Daily

                Software Engineering Daily

                624 Listeners

                Talk Python To Me by Michael Kennedy

                Talk Python To Me

                583 Listeners

                Super Data Science: ML & AI Podcast with Jon Krohn by Jon Krohn

                Super Data Science: ML & AI Podcast with Jon Krohn

                302 Listeners

                NVIDIA AI Podcast by NVIDIA

                NVIDIA AI Podcast

                343 Listeners

                Practical AI by Practical AI LLC

                Practical AI

                204 Listeners

                AWS Podcast by Amazon Web Services

                AWS Podcast

                205 Listeners

                Last Week in AI by Skynet Today

                Last Week in AI

                305 Listeners

                Dwarkesh Podcast by Dwarkesh Patel

                Dwarkesh Podcast

                523 Listeners

                The Data Engineering Show by The Firebolt Data Bros

                The Data Engineering Show

                8 Listeners

                No Priors: Artificial Intelligence | Technology | Startups by Conviction

                No Priors: Artificial Intelligence | Technology | Startups

                129 Listeners

                Latent Space: The AI Engineer Podcast by swyx + Alessio

                Latent Space: The AI Engineer Podcast

                92 Listeners

                This Day in AI Podcast by Michael Sharkey, Chris Sharkey

                This Day in AI Podcast

                227 Listeners

                The AI Daily Brief: Artificial Intelligence News and Analysis by Nathaniel Whittemore

                The AI Daily Brief: Artificial Intelligence News and Analysis

                633 Listeners

                AI + a16z by a16z

                AI + a16z

                36 Listeners