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
                This Week in Startups by Jason Calacanis

                This Week in Startups

                1,299 Listeners

                The Changelog: Software Development, Open Source by Changelog Media

                The Changelog: Software Development, Open Source

                288 Listeners

                The a16z Show by Andreessen Horowitz

                The a16z Show

                1,106 Listeners

                Software Engineering Daily by Software Engineering Daily

                Software Engineering Daily

                630 Listeners

                Risky Business by Risky Business Media

                Risky Business

                372 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

                309 Listeners

                NVIDIA AI Podcast by NVIDIA

                NVIDIA AI Podcast

                346 Listeners

                Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

                Syntax - Tasty Web Development Treats

                987 Listeners

                Practical AI by Practical AI LLC

                Practical AI

                210 Listeners

                Dwarkesh Podcast by Dwarkesh Patel

                Dwarkesh Podcast

                550 Listeners

                The Data Engineering Show by The Firebolt Data Bros

                The Data Engineering Show

                10 Listeners

                Latent Space: The AI Engineer Podcast by Latent.Space

                Latent Space: The AI Engineer Podcast

                104 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

                680 Listeners