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

DBA use cases

The following use cases require you to be connected to an OpenEdge database as a DBA.
Connect to an OpenEdge database as a DBA, dbauser, using the SQL explorer tool:
sqlexp -user dbauser -password abcd -db sports3000 -S 1234 -H localhost
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
* 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