Try OpenEdge Now
skip to main content
Multi-tenancy Overview
Multi-tenancy and OpenEdge SQL : Super tenant use cases
 

Super tenant use cases

The following use cases require you to be connected to an OpenEdge database as a super tenant.
Connect to an OpenEdge database as a super tenant, super_tenant, using the SQL explorer tool:
sqlexp -user super_tenant@DomainOne -password abcd -db sports3000 -S 1234 -H localhost
After connecting as a super tenant, you can:
*Accessdata as a super tenant
*Joinmulti-tenant tables
*Insert rows into a multi-tenant table
*Move rows between partitions in a multi-tenant table
*Updaterows of a tenant partition
*Deleterows of a tenant partition
*Deleterows of a tenant partition
* 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