Defines a super-tenant for a multi-tenant database. A super-tenant is a user who can access and maintain data for any tenant defined in the multi-tenant database. There can be multiple super-tenant users created within a single database.

The multi-tenant database resources are not allocated automatically when you create a super-tenant. Privileges of a regular tenant, such as creating, selecting, inserting, updating, or deleting database objects are also applicable to the super-tenant.

Syntax

The syntax for creating a super-tenant is given below:

CREATE SUPER_TENANT super_tenant_name[ PRO_DESCRIPTION value ];

Example: Creating a super tenant

The following example illustrates how to create a tenant and a domain for the tenant.

CREATE SUPER_TENANT tenantadmin;

For more on the CREATE SUPER_TENANT statement, see OpenEdge SQL Reference.