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 Data Management: SQL Reference.
