Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)ФранцузскийItaliano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Introduction to Database Multi-tenancy

DBA use cases

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Multi-tenancy Overview
    • What is multi-tenancy?
    • What are the advantages of multi-tenancy?
    • What is a tenant?
    • How does data access work?
      • Partition allocation
      • Table types
        • Multi-tenant objects
        • Object allocation
        • Allocation states
        • Multi-tenant table instance
        • Data partitions
        • Default storage area
        • Multi-tenant sequences
    • What is a multi-tenant group?
  • Multi-tenant Feature Capabilities
    • Database Administration Console
    • Data Dictionary support for multi-tenancy
    • Database Administration
    • Database utilities
    • Audit policies
    • Progress Developer's Studio for OpenEdge support
  • Multi-tenancy and ABL
    • ABL Support
      • Run applications in a multi-tenant database environment
      • Code for super-tenant access
        • Super-tenant effective tenant
        • Super-tenant applications
        • Super-tenant queries
        • Super-tenant data updates
        • Tenancy identification
        • Super-tenant sequence access
      • Use multi-tenant sequences with shared tables
      • Configure Safe User ID in a multi-tenant database
    • ABL API for multi-tenant maintenance
      • DataAdminService operations
      • Entity interface members
      • Further information
  • Multi-tenancy and OpenEdge SQL
    • OpenEdge SQL support
    • DBA use cases
      • Define a multi-tenant table
      • Define a multi-tenant sequence
      • Define a multi-tenant Index
      • Alter a regular table to a multi-tenant table
      • Alter a multi-tenant sequence
      • Create a tenant
      • Create a super tenant
      • Alter a tenant
      • Delete a tenant
    • Regular tenant use case (accessing data)
    • Super tenant use cases
      • Access data as a super tenant
      • Join multi-tenant tables
      • Insert rows into a multi-tenant table
      • Move rows between partitions in a multi-tenant table
      • Update rows of a tenant partition
      • Delete rows of a tenant partition
      • View tenant specific information
    • SQL utility use cases
      • Dump tenant data as a regular tenant
      • Dump all tenant data as a super tenant or a DBA
      • Load tenant data as a regular tenant
      • Load tenant data as a super tenant or a DBA
      • Write schema definitions for a multi-tenant table
  • Data partitions
  • Default storage area
  • Domain access code
  • Group/multi-tenant group
  • Multi-tenant objects
  • Multi-tenant sequence
  • Object allocation/allocation state
  • Allocation states
  • Security domains
  • Table types
  • Tenants
  • Tenant ID
  • Tenancy
  • Tenant identity
Table of Contents

DBA use cases

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: April 18, 2023
  • 1 minute read
    • OpenEdge
    • Version 13.0
    • Documentation

The following use cases require you to be connected to an OpenEdge database as a DBA.

After connecting as a DBA, you can:

  • Define a multi-tenant table
  • Define a multi-tenant sequence
  • Define a multi-tenant Index
  • Alter a regular table to a multi-tenant table
  • Alter a multi-tenant sequence
  • Create a tenant
  • Create a super tenant
  • Alter a tenant
  • Delete a tenant
Contents
  • Define a multi-tenant table
  • Define a multi-tenant sequence
  • Define a multi-tenant Index
  • Alter a regular table to a multi-tenant table
  • Alter a multi-tenant sequence
  • Create a tenant
  • Create a super tenant
  • Alter a tenant
  • Delete a tenant
TitleResults for “How to create a CRG?”Also Available inAlert