White Paper: Just-in-Time Database Access Best Practices

Bytebase logo
  • 3-in-1
    • Schema Migration
      GUI-based, database CI/CD with GitOps
    • Permission-based SQL Editor
      Bastion-less human-to-database permission control
    • Dynamic Data Masking
      Role-based multi-level masking policy
    • Batch Change
      Multi-environments, multi-regions, multi-tenants
  • Use Case

    • Planned Database CI/CD
    • Just-in-Time Database Access
    • Adhoc Database Change
    • Large-Scale Deployment
    • Headless Database Backend

    Industry

    • Financial Services
    • Technology
    • Manufacturing
    • Gaming
    • Web3
    • Docs
    • Supported Databases
    • Case Study
    • Blog
    • Company
    TutorialStep-by-step guide through common features.
    Start Learning
  • Pricing
...DemoSelf-host
    3-in-1
    Pricing
  • GitHub
  • Self-hostDemo
    • Why Bytebase
    • Supported Databases
    • Use Cases
    • POC Checklist 📝
    • Best Practices 📘
    • Core Concepts 💡
    • FAQ

      • Self-host
      • Upgrade
      • Configure External PostgreSQL
      • Configure External URL
      • Cloud
      • Step 1 - Deploy with Docker
      • Step 2 - Register Accounts
      • Step 3 - Configure Environments
      • Step 4 - Add an Instance
      • Step 5 - Create a Project
      • Step 6 - Change Schema
      • Step 7 - Query Data
    • Connect Your Database
    • Terraform Provider

      • Overview
        • Batch Change
        • Schema Sync
        • Changelist
        • Stored Procedure
        • Schema Editor
        • Schema Diagram
        • Online Schema Migration
        • Secret Variable
        • Overview
        • Review Policy
        • Review Rules
        • UI Integration
        • CI Integration
        • API
        • Custom Approval
        • Rollout Policy
        • Data Rollback
        • Schema Rollback
        • Change History
        • Schema Drift Detection
          • Overview
          • Slow Query Report
          • Weekly Email Report
          • Index Advisor
        • Webhook
        • Risk Center
        • Issue
        • Schema Template
      • Troubleshoot 🐞
      • Overview
      • GitHub
      • GitLab
      • Bitbucket
      • Azure DevOps
      • Release
      • Overview
      • Query
      • Admin Mode
      • Data Masking
      • Manage SQL Scripts
      • Explore Schema
      • AI Assistant
      • Overview
      • Query
      • Export
      • EXPLAIN
      • Overview
      • Semantic Types
        • Masking Algorithm
      • Global Masking Rule
        • Data Classification
      • Column Masking
      • Masking Exemption

      • Single Sign-On
        • OAuth 2.0
        • OpenID Connect (OIDC)
        • LDAP
      • Roles and Permissions
      • User Groups
      • Custom Roles
      • Audit Log
      • SCIM
      • 2FA
      • Password Restriction
      • Sign-in Restriction
      • Watermark
      • Manage License
      • Production Setup
      • Back up Data
      • Database Change Mode
      • AI Assistant
      • Database Instance
      • Environment Policy
      • Customize Logo
      • Announcement
      • SMTP and Email Delivery
      • Archive
      • Overview
      • Authentication
      • SQL Review
      • Release
      • Plan
      • Rollout
      • Issue
      • SQL Editor
      • Permission
      • Data Classification
      • Audit Log
      • Terraform
      • Slack
      • Jira
      • Supabase
      • Render
      • Neon
      • Server Startup Options
      • Error Code for Bytebase Core
      • Error Code for SQL Advisor
      • Schema Definition Language
    • Why Bytebase
    • Supported Databases
    • Use Cases
    • POC Checklist 📝
    • Best Practices 📘
    • Core Concepts 💡
    • FAQ

      • Self-host
      • Upgrade
      • Configure External PostgreSQL
      • Configure External URL
      • Cloud
      • Step 1 - Deploy with Docker
      • Step 2 - Register Accounts
      • Step 3 - Configure Environments
      • Step 4 - Add an Instance
      • Step 5 - Create a Project
      • Step 6 - Change Schema
      • Step 7 - Query Data
    • Connect Your Database
    • Terraform Provider

      • Overview
        • Batch Change
        • Schema Sync
        • Changelist
        • Stored Procedure
        • Schema Editor
        • Schema Diagram
        • Online Schema Migration
        • Secret Variable
        • Overview
        • Review Policy
        • Review Rules
        • UI Integration
        • CI Integration
        • API
        • Custom Approval
        • Rollout Policy
        • Data Rollback
        • Schema Rollback
        • Change History
        • Schema Drift Detection
          • Overview
          • Slow Query Report
          • Weekly Email Report
          • Index Advisor
        • Webhook
        • Risk Center
        • Issue
        • Schema Template
      • Troubleshoot 🐞
      • Overview
      • GitHub
      • GitLab
      • Bitbucket
      • Azure DevOps
      • Release
      • Overview
      • Query
      • Admin Mode
      • Data Masking
      • Manage SQL Scripts
      • Explore Schema
      • AI Assistant
      • Overview
      • Query
      • Export
      • EXPLAIN
      • Overview
      • Semantic Types
        • Masking Algorithm
      • Global Masking Rule
        • Data Classification
      • Column Masking
      • Masking Exemption

      • Single Sign-On
        • OAuth 2.0
        • OpenID Connect (OIDC)
        • LDAP
      • Roles and Permissions
      • User Groups
      • Custom Roles
      • Audit Log
      • SCIM
      • 2FA
      • Password Restriction
      • Sign-in Restriction
      • Watermark
      • Manage License
      • Production Setup
      • Back up Data
      • Database Change Mode
      • AI Assistant
      • Database Instance
      • Environment Policy
      • Customize Logo
      • Announcement
      • SMTP and Email Delivery
      • Archive
      • Overview
      • Authentication
      • SQL Review
      • Release
      • Plan
      • Rollout
      • Issue
      • SQL Editor
      • Permission
      • Data Classification
      • Audit Log
      • Terraform
      • Slack
      • Jira
      • Supabase
      • Render
      • Neon
      • Server Startup Options
      • Error Code for Bytebase Core
      • Error Code for SQL Advisor
      • Schema Definition Language
    • API

    SQL Editor

    📕 Tutorial - Embed SQL Editor in Your Internal Web Portal

    You can configure database permissions and masking policies via API and embed Bytebase SQL Editor into your own internal web portal.

    Edit this page on GitHub
    Previous articleIssue
    Next articlePermission

    All-in-One Database Workflows

    Schema migrations, adhoc changes, just-in-time (JIT) database access, and data masking in one place.

    đŸ•šī¸ Live Demo
    SOC2 badge

    COMPARISONS

    • vs. Liquibase
    • vs. Flyway
    • vs. CloudBeaver
    • vs. DBeaver
    • vs. Navicat
    • vs. Metabase
    • vs. schemachange
    • vs. Jira

    Product

    • Pricing
    • Changelog
    • Documentation
    • API
    • Supported Databases
    • Security

    RESOURCES

    • Resources
    • Terms
    • Policy
    • Partners

    COMPANY

    • About
    • Brand
    • Contact
    Bytebase LogoBytebase logo
    GithubDiscordTwitterYoutubeLinkedIn

    Š 2025 Bytebase. All Rights Reserved.